have a function but if the answer is a negative I want it to say zero "0"

**LaurieLaurie** · 03-10-2013, 04:54 PM

I have an install date and date of my monthly report, I need to know how many days have lapsed at the time of my report from that install date, some of the entries on my sheet have not been installed yet so they are showing up as a negative number and I need them to show as a zero "0". Also if someone has completed their time during the reporting period, I need the days to stop counting at their removal date. This is a constant sheet that I will be adding too daily and no one will be taken off, so I will be doing a lot of sorting to make my reports to the individual agencies. I am attaching a copy of my worksheet. I appreciate any and all help I can get.

I am not "tech" savvy! Please be easy on me with the jargon! lol

Thank you!

Laurie

PS: if you can explain what the (Tags

thing below is for?

**TMS** · 03-10-2013, 05:08 PM

One way:

G2: =MAX(L2-B2,0)

Regards, TMS

**loginjmor** · 03-10-2013, 05:08 PM

Hi Laurie

Try the attached spreadsheet. To test if it works the way you are expecting, change the report date.

Hope this helps.

**BB1972** · 03-10-2013, 05:12 PM

Laurie, welcome to the forum.

I'm flat out of time right now, but this will get you started:

Please Login or Register  to view this content.

is a formula which tells Excel that if L3 minus B3 is less than 0, return 0; otherwise, return whatever L3 - B3 is. I've popped it in the attached for you.

Hope this helps.