View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Colin Hayes Colin Hayes is offline
external usenet poster
 
Posts: 465
Default Comparing two columns , and giving comparison results in a third.


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