View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default Comparing two columns , and giving comparison results in a third.

=IF(C2A2,"+",IF(A2C2,"-","="))
--
David Biddulph

Colin Hayes wrote:
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.