Try this:

=IF(C1A1,"+",IF(C1<A1,"-","="))

Copy down as needed.

--
Biff
Microsoft Excel MVP


"Colin Hayes" wrote in message
...

Hi All

I have small request for assistance.

In Column A , I have a row of numbers. In column C I have a row of numbers
too , with a formula underlying each.

I need , in column D , for the numbers in A and C to be compared and a
plus sign to be placed in the cells where C is bigger than A , a minus
where C is smaller than A , and an equals sign where C is the same as A.



Can someone help on this , please? Grateful for any assistance.



Best Wishes