snyperj

asked on

# Formula help please

In the below formula:

=IF(I16<$N$10,M16,0)

I16 is a date field and N10 is a date field.

How can I adjust the formula so that if I16 is null, a zero is also returned. Right now it returns the value of M16 when null. Thanks

=IF(I16<$N$10,M16,0)

I16 is a date field and N10 is a date field.

How can I adjust the formula so that if I16 is null, a zero is also returned. Right now it returns the value of M16 when null. Thanks

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

=if(isnull(I16),0,IF(I16<$N$10,M16,0))

or

=if(I16="",0,IF(I16<$N$10,M16,0))

or

=if(I16="",0,IF(I16<$N$10,

ASKER

this one was first and worked for me- so thanks!

=IF(AND(I16<>"",I16<$N$10)

regards, barry