Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
COUNTIF in between rows | Excel Worksheet Functions | |||
Reusing formula | Excel Discussion (Misc queries) | |||
Match then lookup | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions |