| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CompareCurrencyColumns
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
