Thread: CompareCurrencyColumns
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default CompareCurrencyColumns
C1: =IF(A1<B1,"NOT EQUAL","")


"gh" wrote:

I have column A and Column B with currency values in them. I want to
compare A1 to B1 and if they do not equal each other put NOT EQUAL in
C1. How would I do this?

TIA

Reply With QuoteReply With Quote