How to apply more than one IF condition in 1 cell

Cesar · December 18th, 2005, 12:12 PM posted to microsoft.public.excel.misc

i have 3 dates referring to a period and where i want under the formula cells
to have the following
if the value of the header of the table which is dats is between the first 2
dats than 1 for true and 0 for false and if the date in the header is between
the 2nd and third date than 2 for true and 0 for false

what is the formula

Don Guillett · December 18th, 2005, 12:18 PM posted to microsoft.public.excel.misc

try something like this
=if(a1highestdate,1,if(a1nexthighestdate,2,0))

--
Don Guillett
SalesAid Software

"Cesar" wrote in message
...
i have 3 dates referring to a period and where i want under the formula
cells
to have the following
if the value of the header of the table which is dats is between the first
2
dats than 1 for true and 0 for false and if the date in the header is
between
the 2nd and third date than 2 for true and 0 for false

what is the formula

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
copying cell names	Al	General Discussion	3	August 11th, 2005 03:01 PM
How can I get excel to apply values in a cell before or after date	Tom	Worksheet Functions	1	February 21st, 2005 04:55 AM
make a cell empty based on condition	mpierre	Charts and Charting	2	December 29th, 2004 01:01 PM
GET.CELL	Biff	Worksheet Functions	2	November 24th, 2004 07:16 PM
IF E3 & E10 = TRUE set this cell to "Yes", else set to "No"	Timothy L	Worksheet Functions	5	August 27th, 2004 02:28 AM