Returning #VALUE! instead of blank

[Jamesorme]

Good afternoon,

I'm hoping somebody can help with the following formula. Struggling to get the mini-sheet working, i've added the extension but it's greyed out.

Formula =IF(G25*H25=0, "", G25*H25)

G25 and H25 are already running this formula from different cells and are returning blanks fine but when I try multiplying the two blanks together it comes back with #VALUE! unless G and H are populated. Any assistance would be very appreciated.

Thanks

 

[RoryA]

You could use:

=IFERROR(IF(G25*H25=0, "", G25*H25),"")

 

[Fluff]

i've added the extension but it's greyed out.

Have a look here XL2BB Icons greyed out