Greetings!

Purpose: total miles that were driven last night in co. vehicles. i.e. when
they left the parking lot and when they came back the next morning.

Problem: the formula =SUM(('Mileage Log'!E12-'Mileage Log'!E10) 0) gives me
a true (1) false (0) answer. I want it to exclude negative numbers; if it
isnt negative then I want to keep the first value.

On Sundays no one come into work in the morning so it calculates the
formula into a negative number like -48,158 and that throws off any totaling
of how many miles john doe drove. I got that formula to change it from a
negative, thought I had the formula right then realized the 1 meant true is
more than 0. So basically, if its true than I was the answer how it should
be and if its false i.e. a negative then I want it a 0 so I can finnally
make a complete report on driving habits.

THANKS for any help all !!!!
--
~~"Dont Panic"~~ \(^O^)/