| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to apply more than one IF condition in 1 cell
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to apply more than one IF condition in 1 cell
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Instead of a negative number, I'd like to show zero... | Excel Worksheet Functions | |||
| Apply cell shading based on adjacent cells in EXCEL | Excel Worksheet Functions | |||
| Cell color based upon cell value | Excel Discussion (Misc queries) | |||
| cell color index comparison | New Users to Excel | |||
| make a cell empty based on condition | Charts and Charting in Excel | |||
Linear Mode
