Nested IF, simple for you but for me.....

[SandsB]

=IF(F6="","",((B6*C6)+(D6*E6))/F6)

This is driving me crazy. I get #value! if B6 or C6 is blank.

I need the value of ((B6*C6)+(D6*E6))/F6 unless B6 OR C6 are blank. If they are, then I need just (D6*E6)/F6.

Nesting is my downfall.

 

[hagia_sofia]

Hello, are B6 and C6 really empty, i.e. do they not e.g. contain spaces?

 

[SandsB]

Yes. There's a formula in those cells, too. IF blah, blah, blah THEN ""

 

[Alex Blakenburg]

Try:

=IF(F6="","",((N(B6)*N(C6))+(D6*E6))/F6)

 

[SandsB]

Try:

=IF(F6="","",((N(B6)*N(C6))+(D6*E6))/F6)

Thank you, thank you

 

[Alex Blakenburg]

You're welcome. FYI N() just converts any Text Value which of course includes "" to 0 while leaving numbers as numbers.