# Help with IF Function resulting in #value

#### cmccambridge

##### New Member
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!!!

### Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"
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

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?

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

I want Column I to be a 0 or blank

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))

It says I am missing a parenthesis??

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

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

Awesome!, Thanks Excel Genuis

Replies
4
Views
396
Replies
3
Views
243
Replies
9
Views
173
Replies
1
Views
219
Replies
3
Views
210

1,207,402
Messages
6,078,268
Members
446,324
Latest member
JKamlet

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back