Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF and OR question
Hi,
I have 5 conditions in an IF formula and I just cant get it right. Im trying to display a % in cell D10. D10 must display 1% if F12 has the value between 200000 and 249999. D10 must display 2% if F12 has the value between 250000 and 299999. D10 must display 3% if F12 has the value between 300000 and 349999. D10 must display 4% if F12 has the value between 350000 and 399999. D10 must display 5% if F12 has the value is 400000 and above. Thanks, Kirk |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF and OR question
One way:
=IF(F12=400000,5%,IF(F12=350000,4%,IF(F12=30000 0,3%,IF(F12=250000,2%,IF(F12=250000,1%,0))))) -- Jim "Kirk" wrote in message ... | Hi, | | I have 5 conditions in an IF formula and I just cant get it right. Im trying | to display a % in cell D10. | D10 must display 1% if F12 has the value between 200000 and 249999. | D10 must display 2% if F12 has the value between 250000 and 299999. | D10 must display 3% if F12 has the value between 300000 and 349999. | D10 must display 4% if F12 has the value between 350000 and 399999. | D10 must display 5% if F12 has the value is 400000 and above. | | Thanks, | Kirk | |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF and OR question
Thanks Jim, it worked
"Jim Rech" wrote: One way: =IF(F12=400000,5%,IF(F12=350000,4%,IF(F12=30000 0,3%,IF(F12=250000,2%,IF(F12=250000,1%,0))))) -- Jim "Kirk" wrote in message ... | Hi, | | I have 5 conditions in an IF formula and I just cant get it right. Im trying | to display a % in cell D10. | D10 must display 1% if F12 has the value between 200000 and 249999. | D10 must display 2% if F12 has the value between 250000 and 299999. | D10 must display 3% if F12 has the value between 300000 and 349999. | D10 must display 4% if F12 has the value between 350000 and 399999. | D10 must display 5% if F12 has the value is 400000 and above. | | Thanks, | Kirk | |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF and OR question
I have 5 conditions in an IF formula
Hi. Not sure want you want if it's below 200,000 but this idea sets it at your floor of 1% =MEDIAN(1,INT(A1/50000-3),4)/100 -- HTH :) Dana DeLouis "Kirk" wrote in message ... Hi, I have 5 conditions in an IF formula and I just cant get it right. Im trying to display a % in cell D10. D10 must display 1% if F12 has the value between 200000 and 249999. D10 must display 2% if F12 has the value between 250000 and 299999. D10 must display 3% if F12 has the value between 300000 and 349999. D10 must display 4% if F12 has the value between 350000 and 399999. D10 must display 5% if F12 has the value is 400000 and above. Thanks, Kirk |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF and OR question
The problem with this solution, Dana, is that only 5 people in the world
understand it.<g -- Jim "Dana DeLouis" wrote in message ... | I have 5 conditions in an IF formula | | Hi. Not sure want you want if it's below 200,000 but this idea sets it at your floor of 1% | | =MEDIAN(1,INT(A1/50000-3),4)/100 | | -- | HTH :) | Dana DeLouis | | | "Kirk" wrote in message ... | Hi, | | I have 5 conditions in an IF formula and I just cant get it right. Im trying | to display a % in cell D10. | D10 must display 1% if F12 has the value between 200000 and 249999. | D10 must display 2% if F12 has the value between 250000 and 299999. | D10 must display 3% if F12 has the value between 300000 and 349999. | D10 must display 4% if F12 has the value between 350000 and 399999. | D10 must display 5% if F12 has the value is 400000 and above. | | Thanks, | Kirk | |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF and OR question
Oops! The upper limit should be 5%, not 4%. :~
=MEDIAN(1,INT(A1/50000-3),5)/100 -- Dana DeLouis "Jim Rech" wrote in message ... The problem with this solution, Dana, is that only 5 people in the world understand it.<g -- Jim "Dana DeLouis" wrote in message ... | I have 5 conditions in an IF formula | | Hi. Not sure want you want if it's below 200,000 but this idea sets it at your floor of 1% | | =MEDIAN(1,INT(A1/50000-3),4)/100 | | -- | HTH :) | Dana DeLouis | | | "Kirk" wrote in message ... | Hi, | | I have 5 conditions in an IF formula and I just cant get it right. Im trying | to display a % in cell D10. | D10 must display 1% if F12 has the value between 200000 and 249999. | D10 must display 2% if F12 has the value between 250000 and 299999. | D10 must display 3% if F12 has the value between 300000 and 349999. | D10 must display 4% if F12 has the value between 350000 and 399999. | D10 must display 5% if F12 has the value is 400000 and above. | | Thanks, | Kirk | |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF and OR question
"Dana DeLouis" wrote in message
... Oops! The upper limit should be 5%, not 4%. :~ "Jim Rech" wrote in message ... The problem with this solution, Dana, is that only 5 people in the world understand it.<g I'm surprised one of the other four never jumped in before you <g -- Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
where can I see my question and answer? Yesterday I ask a question | Excel Discussion (Misc queries) | |||
Look up question | Excel Worksheet Functions | |||
Newbie Question - Subtraction Formula Question | Excel Discussion (Misc queries) | |||
The question is an excel question that I need to figure out howto do in excel. | Excel Worksheet Functions | |||
iif question | Excel Discussion (Misc queries) |