Dividing negative numbers for result 0

[jkags8]

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:
[TABLE="width: 353"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]Remaining courses to be assigned[/TD]
[TD] (0.32)[/TD]
[/TR]
[TR]
[TD]Available funds for remaining courses[/TD]
[TD] (4,349)[/TD]
[/TR]
[TR]
[TD]Average avail per course for unassigned [/TD]
[TD] 13,592[/TD]
[/TR]
</tbody>[/TABLE]

 

[Roxxien]

If you want an answer to be positive or zero, I suggest you something like this

=IF(B3/C3>0,B3/C3,0)

Edit : I miss readed your post

=IFERROR(IF(B3>0,B3,0)/IF(C3>0,C3,0),0)

 

[jkags8]

Thank you, that works when both numbers are negative. But I need it to work regardless if they're - or +. For example, here's a scenario from a different department:

Remaining courses to be assigned 8
Available funds for courses 50,090
Average available per course 6261

When I use this formula I also get 0 for the average available, instead of the correct value of 6261.

If you want an answer to be positive or zero, I suggest you something like this

=IF(B3/C3>0,B3/C3,0)

Edit : I miss readed your post

=IFERROR(IF(B3>0,B3,0)/IF(C3>0,C3,0),0)

 

[johnmpl]

Hi, to all!

Check this:

Book1
	A	B
1	Remaining courses to be assigned	-0.32
2	Available funds for remaining courses	-4,349
3	Average avail per course for unassigned	0
Hoja3

Cell Formulas
Range	Formula
B3	=IF((B1>0)*(B2>0),B2/B1,)

Blessings!

 

[Aladin Akyurek]

Something like:

=IFERROR(B3 / IF(B2 < 0, 0, B2), 0)