IF Statements

**Brydgy** · 03-15-2011, 06:32 PM

Hi All,
I was directed to this forum as I have an Excel problem. I love Excel and will most definitely make use of this Forum while hopefully helping others. My problem is this...too many arguments for IF statements. This is what I want to do. Hopefully I am sending it correctly:
If <214.99 but >210 = 210 and If<219.99 but >215 = 215 and If<224.99 but >220 = 220 and If <229.99 but >225 = 225 and If<234.99 but >230 = 230.
Thanking in advance yet will thank again.

Glen

**TMS** · 03-15-2011, 06:46 PM

Maybe, one way, assuming the value is in cell A2:

=IF(A2<210,"",IF(A2<215,210,IF(A2<220,215,IF(A2<225,220,IF(A2<230,225,IF(A2<235,230,""))))))

as you don't say what you want outside the extremes, I've opted for blanks.

Regards

**MarvinP** · 03-15-2011, 06:49 PM

Hi Glen and welcome to the forum,

Vlookup will work for you if you use the Approximate Match. That would be having the last argument True.

Find the attached with the answer.

**TMS** · 03-15-2011, 06:56 PM

Another option:

=HLOOKUP(C5,{0,210,215,220,225,230,235},1,TRUE)

assuming the value is in cell C5

Regards

**Brydgy** · 03-15-2011, 08:57 PM

Originally Posted by MarvinP

Hi Glen and welcome to the forum,

Vlookup will work for you if you use the Approximate Match. That would be having the last argument True.

Find the attached with the answer.

Hi Marvin,
Thanks for the welcome and for aiding me in my quest. I tried your response and it worked like a dream. I will try the others at a later date. Thanks to all who responded.

Glen