#value!

Trevor3007

Active Member
Joined
Jan 26, 2017
Messages
493
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
 
Last edited:

BarryL

Well-known Member
Joined
Jan 20, 2014
Messages
1,421
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

Well-known Member
Joined
Jun 29, 2014
Messages
5,146
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,"")
 

Forum statistics

Threads
1,082,586
Messages
5,366,476
Members
400,892
Latest member
lamarh755

Some videos you may like

This Week's Hot Topics

Top