hi, new value formula question
Try something like this:
=IF(OR(N101.749,N10=0),0,(1.75-N10)*200)
Does that help?
***********
Regards,
Ron
XL2002, WinXP
"RayB" wrote:
ok, you all were perfect last question. Now I have a three way value I'm
trying to imput. The formula I'm using presently is this:
=IF(N101.749,0,(1.75-N10)*200)
It works fine.
The problem that I have is this - If N10=0 I'd like the answer to be 0.
If N10 1.75 I'd like the
answer to be 0.
If N10 is not 0, but is less
than 1.75 then I want to use the 1.75-N10*200 formula.
Thanks!
|