Hi there,

I'm setting up a formula to calculate hours of vacation based on a schedule
that increments by years of service.

I have the formula set up and working, with the one hitch that when there is
no date of joining entered, the formula enters the highest amount of vacation
allocated. There will eventually be a date of joining for each person on the
list, but for now I would like the formula result to be blank if there is
none.

I think I am missing a [value_if_false] attribute, but I can't figure out
exactly where. Or, I could put another if statement on the final
date-of-joining condition to say if it's null, then print "0", otherwise
carry out the rest of that condition?

Could someone take a look at the formula and lend some advice? My head hurts.

Thank you!


=IF((DATEDIF(J37,NOW(),"y"))=18,(6*35*F37),IF((DA TEDIF(J37,NOW(),"y"))=12,(5*35*F37),IF((DATEDIF(J 37,NOW(),"y"))=6,(4*35*F37),IF((DATEDIF(J37,NOW() ,"y"))=1,(3*35*F37),"0"))))