If statement - percentages and numbers

[milo1984]

Hi,

I have a simple IF statement, but a small problem. My column of data is a mixture of percentages and numbers. The formula needs to be 'If it is a percentage, IF(E7<D7,"N","Y") and if it is a number (IF(E7>D7,"N","Y"). Can I get the formula to work out if the cell is a percentage?

Unfortunately, some of the numbers are 0 and so I can't even do a <1 scenario.

Any help would be greatly appreciated.

MTIA

[Winon]

Hello milo1984,

The way I would do it is by making use of two helper Columns, which you may place anywhere on the Sheet, change the Formula to refer to those Columns, and all should be well.

Please see the attached sample Workbook.

Hope that helps!