Help with IF Function resulting in #value

[cmccambridge]

Can anyone help me format this formula so that it doesn't show #value when the cells it references are blank

=IF(H147=1,G147*B109,G147*B110)

It works fine if the cells referenced have values in them


Help!


Thanks!!!

 

[RJPotts]

Can anyone help me format this formula so that it doesn't show #value when the cells it references are blank

=IF(H147=1,G147*B109,G147*B110)

It works fine if the cells referenced have values in them


Help!


Thanks!!!

That works fine for me even if none of those cells have any value in them.

Do you have text in one of those cells?

Best regards
Richard

 

[Jonmo1]

Yes, works for me as well if cells are "Blank".
The formula simply treats the blanks as 0 and returns 0.

Are those cells populated by a formula that is returning "" ?
That will cause an error.

What do you want to actually happen when any of these cells(or all of them) are blank?

 

[cmccambridge]

G147 is this formula: =IF(E115=0,"",(F115-E115)*24

 

[cmccambridge]

I want Column I to be a 0 or blank

 

[Jonmo1]

OK, is G147 the only cell that is a formula like that? The other 3 are TRUE blank empty cells ?
=IF(IF(G147="","",IF(H147=1,G147*B109,G147*B110))

 

[cmccambridge]

It says I am missing a parenthesis??

 

[Jonmo1]

Wow, don't know what happened there...
Should be
=IF(G147="","",IF(H147=1,G147*B109,G147*B110))

 

[cmccambridge]

And the 2 of the cells are numbers B109 B110, H147 is a list with 2 values

 

[cmccambridge]

Awesome!, Thanks Excel Genuis