#value!

[Trevor3007]

hi,



I inserted =IF(B16>0,B16*O10), but if B16 is blank i get '#value!' error , how can I resolve?

FYI - cell 010 formatting = Currency (2 decimal places)

KR
Trevor3007

 

[BarryL]

what result do you want if its blank?

possible solution : =IFERROR(IF(B16>0,B16*O10),"")

note this will return FALSE if B16 was negative

 

[jtakw]

Hi,

That "Blank" in B16 must be a Formula Blank ( "" ), not truly blank/empty, otherwise you'll get FALSE rather than #VALUE with your current formula, try this:

=IF(AND(B16>0,B16<>""),B16*O10,"")

 

[Scott Huish]

Also:

=IF(N(B16)>0,B16*O10,"")

 

[Trevor3007]

Also:

=IF(N(B16)>0,B16*O10,"")

heyho BarryL

thanks...works a treat