hi, new value formula question
 

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!

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!

hi, new value formula question
 

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

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"RayB" wrote in message
...
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!

hi, new value formula question
 

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!

hi, new value formula question
 

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!

hi, new value formula question
 

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!