Posted to microsoft.public.excel.misc

David Biddulph[_2_] David Biddulph[_2_] is offline

external usenet poster

Posts: 8,651

'plus or minus' conditional operation

What does the ABS(A1)=0 test do?
--
David Biddulph

"King of Salem" wrote in message
...
It seems that what ended up working for me was:

=IF(AND(ABS(A1)=0,ABS(A1)<=0.5),"Pass","Fail")

Thank you for your assistance!!

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
CHANGE TRAILING MINUS TO BRACKETS OR PRECEEDING MINUS	Socal Analyst looking for help	Excel Discussion (Misc queries)	2	May 12th 06 07:17 PM
Curious operation of Paste	Fred Smith	Excel Discussion (Misc queries)	1	March 24th 06 12:02 PM
what does $ operation mean	JO	New Users to Excel	1	December 15th 05 11:42 PM
ilegal operation	emilija	Links and Linking in Excel	1	January 20th 05 12:24 AM
Conditional operation	Shetty	Excel Worksheet Functions	1	January 17th 05 01:08 PM

All times are GMT +1. The time now is 01:05 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us