How do I limit formula results to positive only?

M

mathjegna

I am working a drivers logbook formula for 80 hours in 7 days with a reset to
zero when a driver has a day off.
My problem is when the day off resets the hours to zero the next calculation
is giving me a negative number of hours.
I am using the formula =IF(F11>0,G10+F11-F4,0) where F11 is the current work
day G10 is the previous total hours and F4 is the hours from 7 days prior.
The problem is on day F12 if the hours worked are less than F5 the cell
records a negative number and then uses it in the following calculations.
I need to limit the time to positive only, how do I get the cell value to
remain zero if the formula provides a negative result?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cumulative formula for word table 0
Pls Help - blank cell/formula issue 7
Subtracting positive amts from negative and positive from positive 3
Help with a formula for a Time Sheet. 1
How to change numbers from positive to negative. 2
IF Statement accepting only positive values 1
Formula for calculating target hours against actual hours 12
Negative value to positive 13

Top