nested if statements excel

Microsoft Ms sla excel lic/sa 2yr-1
June 3, 2010 at 07:23:41
Specs: Windows XP
Can someone please tell me where my error is in this IF statment?

=IF(AND(N3=1,O3<DATE(2010,7,6),1,IF(AND(N3="OUT",O3<DATE(2010,7,6),1,"Out"))))


See More: nested if statements excel

Report •


#1
June 3, 2010 at 17:36:33
Excel question are best asked in the Office Software forum,
that being said, it looks like you did not close off your AND functions.

Try this:

=IF(AND(N3=1,O3<DATE(2010,7,6)),1,IF(AND(N3="OUT",O3<DATE(2010,7,6)),1,"Out"))))

MIKE

http://www.skeptic.com/


Report •
Related Solutions


Ask Question