Hi, I want to keep a cell blank when using a formula based off multiple blank cells, is this possible? Struggled to find anything googling. It's in relation to calculating cbm if that helps.
Columns A/B/C are H/W/D (in mm)
Column D is formula to calculate cbm
CBM calculation is HxWxD, however as I'm using mm I need to divide by 1000 to get m
I want the column D to be blank if no data entered in A/B/C but its just giving me #VALUE! or #SPILL!
I tried this:
=IF(OR(A1=0,B1=0,C1=0),"",((A1/1000)*(B1/1000)*(C1/1000)))
Also tried:
=IF(ISBLANK(A1:C1=0),"",((A1/1000)*(B1/1000)*(C1/1000)))
=IF(A1:C1=0,"",((A1/1000)*(B1/1000)*(C1/1000)))
