Nested IFBlank with variable formula

[Treamaya]

Would anyone be wiling to tell me how to write this in an excel formula?

IF B9 is not blank,
Then
IF C7>8,
Then "variable1"*C7
Else "Variable2"*C7
Else, 0

In other words, if B9 is blank, return no value. IF it is not blank, then check to see if C7's value is greater then 8. If it is multiply variable1 against C7 and if it is not then multiply variable2 against C7.

 

[par60056]

something like:
=IF(ISBLANK(B9),IF(C7>8,5*C7,13*C7),0)

 

[Scott Huish]

=IF(B9="",0,IF(C7>8,5,13)*c7)

Replace the 5 and 13 with your actual values or cell references

 

[Treamaya]

thank you! this works well

 

[Treamaya]

Thank you for the quick reply!

However I was only getting a zero returned with this formula.

 

[Scott Huish]

Can you post your actual formula, sample data and expected results?
Because it worked fine for me:

Excel 2010
	A	B	C
1	45
2
3
4
5
6
7			9
8
9		not blank
Sheet1

Cell Formulas
Range	Formula
A1	=IF(B9="",0,IF(C7>8,5,13)*C7)

 

[Treamaya]

Here are the 2 formulas that I ended up using...

=IF(ISBLANK(D73),0,(IF(E70<9,TwoTonePaint*L73,((TwoTonePaint*L73)+(paint9*L73)))))


=IF(ISBLANK(D61),0,TwoTonePaint*L61)

"Twotonepaint" is a named cell on a different page.