JE McGimpsey

Posts: n/a

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 With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
show macro security setting in a cell	Mark	Excel Worksheet Functions	3	March 21st 05 07:53 AM
Addition to Turn cell red if today is greater or equal to date in cell	Rich	New Users to Excel	2	December 9th 04 02:06 AM
Cell doesn't show formula result - it shows formula (CTRL + ' doe.	o0o0o0o	Excel Worksheet Functions	6	November 19th 04 03:13 PM
Show a date based on today	DJ Dusty	Excel Worksheet Functions	2	November 12th 04 03:20 AM
How to verify that 3 cells are equal	Scott	Excel Worksheet Functions	1	November 9th 04 10:24 PM

All times are GMT +1. The time now is 04:26 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us