Sher10

Junior Member

Posts: 5

Thankyou so much. That worked perfectly.

Quote:

Originally Posted by joeu2004[_2_]

"Sher10" wrote:
I want a comment to appear if the variance is Greater
than $5 or greater than ($5). I have used the formula
=if(and(m18<-5, M185), "PROVIDE COMMENT", "")

Ostensibly, change "AND" to "OR", to wit:

=if(or(m18<-5,m185),"...comment...","")

Alternatively, you could write:

=if(abs(m18)5,"...comment...","")

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode 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
SMALL function to find X smallest number greater than Y	kittronald	Excel Worksheet Functions	6	June 15th 11 12:35 AM
Greater than less than in a find function	aintlifegrand79	Excel Programming	5	June 25th 08 05:00 PM
What is the VBA function to return the greater of two integers?	[email protected]	Excel Programming	9	January 4th 08 10:05 PM
How do I filter a list using a greater than todays date function?	LV	Excel Worksheet Functions	2	April 29th 05 06:07 PM
Less than Greater than function	GreenMonster	Excel Worksheet Functions	7	March 4th 05 11:04 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us