ExcelBanter - Show value or not equal

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

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

- - Show value or not equal (https://www.excelbanter.com/excel-worksheet-functions/7756-show-value-not-equal.html)

Pat

Show value or not equal

=IF(L77+K77=A77, "Equals","not equal")

Rather than displaying "Equals" I would prefer the value to be displayed. If
it is "not equal" this should remain as displayed.

Can anyone help with this?

Thanks
Pat

JE McGimpsey

One way:

=IF(L77+K77=A77,A77,"not equal")

In article ,
"Pat" wrote:

=IF(L77+K77=A77, "Equals","not equal")

Rather than displaying "Equals" I would prefer the value to be displayed. If
it is "not equal" this should remain as displayed.

Can anyone help with this?

Thanks
Pat

All times are GMT +1. The time now is 03:41 PM.