My spreadsheet is for a college. I have two cells - one shows how many courses are left to be assigned (to an instructor), the others shows the total remaining available funds. I divide them to show the average funds available for each course instructor.
Sometimes the numbers are positive, sometimes they're negative. If they're negative or 0 (ie you have no courses left to hire for, or you've hired too many people, or you've spent too much money) I want the calculation to show 0. Currently dividing two negative numbers yields a positive result, so if they're overhired or overspent it looks like they still have funds.
Thanks for the help.
Example:
<colgroup><col><col></colgroup><tbody>
</tbody>
Sometimes the numbers are positive, sometimes they're negative. If they're negative or 0 (ie you have no courses left to hire for, or you've hired too many people, or you've spent too much money) I want the calculation to show 0. Currently dividing two negative numbers yields a positive result, so if they're overhired or overspent it looks like they still have funds.
Thanks for the help.
Example:
Remaining courses to be assigned | (0.32) |
Available funds for remaining courses | (4,349) |
Average avail per course for unassigned | 13,592 |
<colgroup><col><col></colgroup><tbody>
</tbody>