and and if functions

F

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
 
J

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top