Or even =(1.75-MIN(N10,1.75))*200*(N10<0)
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"driller" wrote in message
...
maybe this way i am not more confused

=200*(1.75-(N100)*(N10<1.75)*N10)
just try
--
*****
birds of the same feather flock together..



"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!