and if??

David · Oct 16, 2003

I'm trying to check if two conditions are met, to use the
value in a non related cell.

For example, if a date is greater than the start date and
less than the end date, enter a value from A1, else enter
0.

Any thoughts?

Thanks, David.

Chip Pearson · Oct 16, 2003

David,

Try something like
=IF(AND(dateval>=startdate,dateval<=enddate),A1,0)

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com [email protected]

Peo Sjoblom · Oct 16, 2003

In the non related cell enter

=IF(AND(date_cell>start_date_cell,date_cell<end_date_cell),A1,0)

an example could look like

=IF(AND(D1>B1,D1<C1),A1,0)

and if??

David

Chip Pearson

Peo Sjoblom