hi, new value formula question

[Guest]

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(N10>1.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!

 

[Bernard Liengme]

An IF-less solution
=(1.75-N10)*200*(AND(N10<1.75,N10<>0))

 

[Guest]

maybe this way i am not more confused

=200*(1.75-(N10>0)*(N10<1.75)*N10)
just try

 

[Guest]

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.

 

[Bernard Liengme]

Or even =(1.75-MIN(N10,1.75))*200*(N10<>0)