Ron and Bernard,
both solutions worked perfectly. That's really great. As I stated before,
I'm a novice Excel user whose muddling along and some of the conditional help
files are challenging. Thank you for the excellent answers!

Driller, that solution doesnt appear to work for the problem, but I
appreciate the reply. I probably didnt explain it well. But its solved and
I appreciate it.

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