IF and OR question

[Kirk]

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

 

[Jim Rech]

One way:

=IF(F12>=400000,5%,IF(F12>=350000,4%,IF(F12>=300000,3%,IF(F12>=250000,2%,IF(F12>=250000,1%,0)))))

--
Jim
| 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
|

 

[Kirk]

Thanks Jim, it worked

 

[Dana DeLouis]

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

 

[Jim Rech]

The problem with this solution, Dana, is that only 5 people in the world
understand it.<g>

--
Jim
|> 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
|
|
| > 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
| >

 

[Sandy Mann]

Oops! The upper limit should be 5%, not 4%. :>~

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk