Posted to microsoft.public.excel.misc

King of Salem King of Salem is offline

external usenet poster

Posts: 1

'plus or minus' conditional operation

I am trying to determine whether or not a value falls within a specification.
If A1 is -0.285, for example, and I want to say IF(ABS(A1)=0Â±0.5, "Pass",
"Fail") This will allow me to quickly see that if A1 is 0 plus or minus 0.5,
then it displays whether A1 passes the specification or not. Any suggestions?

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
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 03:45 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us