excel formula help

[john]

I need a cell to calculate the following:
IF C EQUALS BETWEEN 1201 - 3200 = RESULT 125
IF C EQUALS BETWEEN 3201 - 10000 = RESULT 200
IF C EQUALS BETWEEN 10001 AND ABOVE = RESULT 315


CAN ANYONE HELP?

Thanks

 

[Claus Busch]

Hi John,

Am Thu, 16 Aug 2012 03:25:58 -0700 (PDT) schrieb john:

I need a cell to calculate the following:
IF C EQUALS BETWEEN 1201 - 3200 = RESULT 125
IF C EQUALS BETWEEN 3201 - 10000 = RESULT 200
IF C EQUALS BETWEEN 10001 AND ABOVE = RESULT 315

try:
=VLOOKUP(C1,{0,0;1201,200;3200,250;10001,315},2,1)


Regards
Claus Busch

 

[Claus Busch]

Hi John,

Am Thu, 16 Aug 2012 12:39:09 +0200 schrieb Claus Busch:

=VLOOKUP(C1,{0,0;1201,200;3200,250;10001,315},2,1)

^^^^
sorry, in the formula above is a typo
=VLOOKUP(C1,{0,0;1201,200;3201,250;10001,315},2,1)


Regards
Claus Busch

 

[John Jones]

I need a cell to calculate the following:
IF C EQUALS BETWEEN 1201 - 3200 = RESULT 125
IF C EQUALS BETWEEN 3201 - 10000 = RESULT 200
IF C EQUALS BETWEEN 10001 AND ABOVE = RESULT 315

use a table:
0 0
1201 125
3201 200
10001 315

and the formula
=VLOOKUP(C11,I5:J8,2,TRUE)

replace C11 with the address of C
replace I5:J8 with the range of the table on your sheet.

you didnt specify what happens if C<1201 but that can be accomodated by
adjusting the table (I assumed C>=0 and result=0 if C<1201)

You could use an 'orrible nested IF formula but I wouldnt recommend
that.

HTH
JJ

 

[johnmoore491985]

Hi John, Am Thu, 16 Aug 2012 12:39:09 +0200 schrieb Claus Busch: > =VLOOKUP(C1,{0,0;1201,200;3200,250;10001,315},2,1) ^^^^ sorry, in the formula above is a typo =VLOOKUP(C1,{0,0;1201,200;3201,250;10001,315},2,1) RegardsClaus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2

Just coming up with #n/a
any chance i can email you it for you to have a play? was supposed to have this done by 12 but not looking that way
Thanks

 

[johnmoore491985]

I need a cell to calculate the following: IF C EQUALS BETWEEN 1201 - 3200 = RESULT 125 IF C EQUALS BETWEEN 3201 - 10000 = RESULT 200 IF C EQUALS BETWEEN 10001 AND ABOVE = RESULT 315 CAN ANYONE HELP? Thanks

managed to get it working....great!!!!! thanks very much

 

[kozuki7]

I need a cell to calculate the following:

IF C EQUALS BETWEEN 1201 - 3200 = RESULT 125

IF C EQUALS BETWEEN 3201 - 10000 = RESULT 200

IF C EQUALS BETWEEN 10001 AND ABOVE = RESULT 315





CAN ANYONE HELP?



Thanks

I see below you got it working, but in the future, if you don't want to have to use a VLOOKUP, you can always use nested IF formulas:

=IF(C1<1201,"Outside scope",IF(C1<3201,125,IF(C1<10001,200,315)))