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

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
|

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
|

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

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
|

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
|

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