ExcelBanter - CompareCurrencyColumns

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - CompareCurrencyColumns (https://www.excelbanter.com/excel-worksheet-functions/167376-comparecurrencycolumns.html)

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

Teethless mama

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

All times are GMT +1. The time now is 06:00 AM.