and and if functions

[Fesco]

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]

Are you looking to combine the formula like the below

=if (OR(isblank (b4),b4<=C2) ,1,0)

If this post helps click Yes