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