I'm working on a spreadsheet to break down hourly cost of a salary employee, depending on billable hours.
So, his Daily cost is a constant, call it CS (for Consistant Salary). His total billable hours per day will be TH. His per-job hours will be JH.
My function is (CS/TH)*JH.
If he spends no time on a job, i'd get a divide by zero error. Is there a way to invert this so instead of diving by zero i'm multiplying by One over something?