| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
and and if functions
I am trying to make formula for two conditions on column C to get the
bednights. =if (isblank (b4) ,1,0) and =if(b4<=C2,1,0). 1 A B C 2 ENTER DATE "EXITDATE" 07/01/09 3 Bednights 4 10/9/2008 07/15/09 1 5 10/9/2008 07/15/09 1 6 10/9/2008 07/15/09 1 7 10/9/2008 07/15/09 1 8 12/17/2008 1 Appreciate any help. Thanks, Jina |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
and and if functions
Are you looking to combine the formula like the below
=if (OR(isblank (b4),b4<=C2) ,1,0) If this post helps click Yes --------------- Jacob Skaria "Fesco" wrote: I am trying to make formula for two conditions on column C to get the bednights. =if (isblank (b4) ,1,0) and =if(b4<=C2,1,0). 1 A B C 2 ENTER DATE "EXITDATE" 07/01/09 3 Bednights 4 10/9/2008 07/15/09 1 5 10/9/2008 07/15/09 1 6 10/9/2008 07/15/09 1 7 10/9/2008 07/15/09 1 8 12/17/2008 1 Appreciate any help. Thanks, Jina |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to convert cell formula functions to code functions | Excel Discussion (Misc queries) | |||
| formula/functions for average and if functions | Excel Worksheet Functions | |||
| efficiency: database functions vs. math functions vs. array formula | Excel Discussion (Misc queries) | |||
| Looking for a site with functions that substitute the ATP functions | Excel Worksheet Functions | |||
| Nesting functions in the functions dialog box | Excel Worksheet Functions | |||
Linear Mode
