| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| show macro security setting in a cell | Excel Worksheet Functions | |||
| Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
| Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions | |||
| Show a date based on today | Excel Worksheet Functions | |||
| How to verify that 3 cells are equal | Excel Worksheet Functions | |||
Hybrid Mode
