Keeping cell blank when using a formula if multiple cells are blank

Copper Contributor

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: 


Also tried:



1 Reply




=IF(OR(A1:C1=""), "", A1*B1*C1/1000000000)