Here you go:

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

Does that help?

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

XL2002, WinXP-Pro


"At A Loss" wrote:

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.

On Mon, 13 Mar 2006 07:49:27 -0800, Ron Coderre
wrote:

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


"At A Loss" wrote:

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