Posted to microsoft.public.excel.misc

Douglas Eckert Douglas Eckert is offline

external usenet poster

Posts: 32

Nested Ages Plus or Minus (IF)

Dave O: Thanks.

DOUG

"Dave O" wrote:

How about
=IF(ABS(A1-B1)<=1,"Yes","No")
where A1 and B1 are the age fields.

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
Calculating ages	Lynne	Excel Discussion (Misc queries)	1	November 14th 06 03:24 AM
calculating ages	pama	Excel Worksheet Functions	3	November 7th 06 07:21 PM
CHANGE TRAILING MINUS TO BRACKETS OR PRECEEDING MINUS	Socal Analyst looking for help	Excel Discussion (Misc queries)	2	May 12th 06 07:17 PM
dates into ages	Caz	Excel Worksheet Functions	1	February 28th 06 04:10 AM
how can i show two layers of plus/minus signs for nested groups	pspiel	Excel Discussion (Misc queries)	7	August 18th 05 08:03 PM

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

About Us

"It's about Microsoft Excel"