IF Function returns FALSE

[Gulfman100]

The following formula returns FALSE when the first IF condition is not met. I
want to return a blank cell or a 0. The other 2 IF formulas are working
correctly. I have tried everything I can think of. Please help.

=IF(B3=9,IF(B7=16,(B6*12/16)+(3*B8)+(4*B9)+(B10*8),IF(B7=24,(B6*12/24)+(3*B8)+(4*B9)+(B10*8),0)))

 

[fredg]

The following formula returns FALSE when the first IF condition is not met. I
want to return a blank cell or a 0. The other 2 IF formulas are working
correctly. I have tried everything I can think of. Please help.

=IF(B3=9,IF(B7=16,(B6*12/16)+(3*B8)+(4*B9)+(B10*8),IF(B7=24,(B6*12/24)+(3*B8)+(4*B9)+(B10*8),0)))

You have posted this question to the wrong newsgroup.
The access in this groups title refers to Microsoft Access, a database
program.
Please repost to the correct newsgroup for the Excel program you are
using.
I would suggest you include your Windows and Office version number in
your message. It might make a difference.

 

[stumac]

As Fred says, you would probably get a better response for this if you posted
this in an Excel forum. however that said - you have not put a value to be
retuenred if the IF statement is false. therefor it will return false. Try:

=IF(B3=9,IF(B7=16,(B6*12/16)+(3*B8)+(4*B9)+(B10*8),IF(B7=24,(B6*12/24)+(3*B8)+(4*B9)+(B10*8),0)),0)

(note the ",0" before the closing bracket).

hth

Stu

 

[stumac]

As Fred says, you would probably get a better response for this if you posted
this in an Excel forum. however that said - you have not put a value to be
retuenred if the IF statement is false. therefor it will return false. Try:

=IF(B3=9,IF(B7=16,(B6*12/16)+(3*B8)+(4*B9)+(B10*8),IF(B7=24,(B6*12/24)+(3*B8)+(4*B9)+(B10*8),0)),0)

(note the ",0" before the closing bracket).

hth

Stu

 

[stumac]

As Fred says, you would probably get a better response for this if you posted
this in an Excel forum. however that said - you have not put a value to be
retuenred if the IF statement is false. therefor it will return false. Try:

=IF(B3=9,IF(B7=16,(B6*12/16)+(3*B8)+(4*B9)+(B10*8),IF(B7=24,(B6*12/24)+(3*B8)+(4*B9)+(B10*8),0)),0)

(note the ",0" before the closing bracket).

hth

Stu