#VALUE error

[GAcuren]

I have a formula on each row =IF(C50>0,AI50*D50*B50,"").

currently if there is no data the row is returning #value! and therefore, I cannot sum the column.

I would like for the cell to stay blank until data is input in the cells so that I can sum the column.

thank you in advance for the formula!

 

[ISY]

Hi,

=IF(C50>0,AI50*D50*B50,0)

 

[GAcuren]

Hi,

=IF(C50>0,AI50*D50*B50,0)

Not working:

 

[GAcuren]

I need these to stay blank until I input the data.

=IF(C64>0,LOOKUP(C64,CONSUMABLES!B$4:B$60,CONSUMABLES!D$4:D$59),"")
=IF(C64>0,B64*D64,"")

currently error reported: #N/A and #Value!

 

[RoryA]

You could use:
=IF(C64>0,XLOOKUP(C64,CONSUMABLES!B$4:B$60,CONSUMABLES!D$4:D$60,""),"")
=IF(C64>0,IFERROR(B64*D64,""),"")