View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
srctr srctr is offline
external usenet poster
 
Posts: 24
Default Adding 2 cells only if one is not over

I am trying to create an Attendance Calendar. We are allotted only a certain
number of days (can't go over that). But we get a day each month. I need
the formula to add Allotted Days + Carry over days and minus Total days used
that month but never go over 36 days.

Allotted Days + Carry Over Days -Total days used = Total Days left (never to
exceed 36 days)

Thanks in advance for any help with this problem.

--
cao