Using the If rule

**Cmorgan** · 07-03-2012, 03:48 AM

Morning,

Any help would be greatly appreciated:

I am trying to use a formula that will give me a Y if the figure in the cell is higher than 2, and a N if the figure in the cell is lower than 3. Any ideas, I was trying this: =IF(ER2>2,"Y",IF(ER2<3,"N")) but it didn't work.

Thanks for any help.

**zbor** · 07-03-2012, 03:50 AM

Try: =IF(ER2>2,"Y","N")

But what if ER is 2.5?

**tom1977** · 07-03-2012, 03:51 AM

Hi
And what about 2,5??

**Fotis1991** · 07-03-2012, 04:11 AM

Hi

....And what about 2,5??

..And not only... Any number up to 2 will show "Y"(Even if will be more than 3!...

**vlady** · 07-03-2012, 04:20 AM

2.1
2.2
2.3
2.4
2.5
2.6
2.7
2.8
2.9

are all greater than 2 and lower than 3

**Cmorgan** · 07-03-2012, 04:23 AM

Thanks guys, as it is only whole numbers it doesn't matter. However, I've realised I have few blanks so I need the formula below to leave the cell blank if ER is blank:

Try: =IF(ER2>2,"Y","N")

Thanks for any ideas.

**Philb1** · 07-03-2012, 04:52 AM

Please Login or Register  to view this content.

**Cmorgan** · 07-03-2012, 05:02 AM

Thanks guys, much appreciated

**KUMAR.PON** · 07-03-2012, 05:09 AM

Hi!
Pl give a little more thought: Any number >2 even 10000 is acceptable as per the first part.
" IF(ER2<3,"N") " will work only if the number is <=2 as the 2nd "IF" will be examined only if the first "IF" condition is not satisfied.
Pl think over again: What do you want exactly? If you want the Excel to say Y to numbers >2 then you can write : IF(ER2>2,"Y","N")