Logical Value

A

At A Loss

When using a IF formula, one answer is false.
Can the word FALSE be changed to a zero?
Would appericate a "simple" example...
Thanks in advance
 
R

Ron Coderre

Without an example of the formula you're using or what you're trying to
accomplish, I can only guess...

Perhaps something like this:

=IF(A1=5,1000,0)
That formula test if the value of A1 is 5.
If TRUE, then return 1000
If FALSE, then return 0

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro
 
G

Gary''s Student

You can convert FALSE to zero as follows:

=(1=2) will return FALSE
=(1=2)*1 will return zero
 
A

At A Loss

Ron, Here is my formula:
=IF(G2=0,0,IF(G2>=4,VLOOKUP(G2,J2:K8,2)))
Hope the formula makes sense!!
Appericate your time and help on this.
 
R

Ron Coderre

Here you go:

=IF(G2=0,0,IF(G2>=4,VLOOKUP(G2,J2:K8,2),0))

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro
 
R

Ron Coderre

Alternatively, couldn't you just use this?

=IF(G2>=4,VLOOKUP(G2,J2:K8,2),0)

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro
 
Top