ExcelBanter - and and if functions

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - and and if functions (https://www.excelbanter.com/excel-discussion-misc-queries/239409-if-functions.html)

Fesco

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

Jacob Skaria

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

All times are GMT +1. The time now is 06:29 AM.