Any Excel gurus around? - Cigar Asylum Cigar Forum

		Cigar Asylum Cigar Forum > Non Cigar Specialty Forums > Misc > Networking
Any Excel gurus around?

Today's Posts

Thread Tools

Display Modes

08-29-2016, 12:20 PM

pnoon

YNWA

Join Date: Oct 2008

First Name: Peter

Location: San Diego

Posts: 29,919

Trading: (20)

Re: Any Excel gurus around?

Quote:

Originally Posted by markem

This line works for me:

=IF((ABS(B1-A1)<1.5), "TRUE", "FALSE")

the column information is spreadsheet specific, but you get the idea.

I'm only guessing here but I would assum the boundary condition of 1.5 would be a positive result. If so, reversing the sign and results will do the trick

=IF((ABS(B1-A1)>1.5), "FALSE", "TRUE")

The literals could also be changed to PASS/FAIL, YES/NO, etc.

__________________
Be more concerned with your character than your reputation, because your character is what you really are, while your reputation is merely what others think you are.
-John Wooden

« Previous Thread | Next Thread »

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off

Forum Jump

All times are GMT -6. The time now is 12:41 AM.