Multi If Statement (Excel 93)

Topic

New Reply

In column C of the attached, I need an additional IF statement added to my existing formula that would change the 0 value to 1. I am not sure where to insert that addtl statement.

Thanks for your help.

Reply | Quote

Replies

Do you mean in column D? (There are no formulas in column C)

Try

=MAX(1,IF(OR(WEEKDAY(A2)=1,WEEKDAY(A2)=7),IF(NETWORKDAYS(A2,C2,Holiday)0.5,IF(NETWORKDAYS(A2,C2,Holiday)-1<1,1,NETWORKDAYS(A2,C2,Holiday)-2),NETWORKDAYS(A2,C2,Holiday))))

Reply | Quote

I did mean Column D. Mucho thanks!!

Have a super weekend!!!

Marie

Reply | Quote