Hi!
Here's one way.
E1 = miles driven
=IF(E1="","",E1-LOOKUP(E1,{0,0;1,50;100,25;200,0}))
Biff
-----Original Message-----
Okay working on a timesheet--still--
I need to be able to take the total number of miles
driven and subtract a
fixed number based on the total number of miles driven.
For 1-99 miles subtract 50 miles--so for 91 miles driven
I need it to show
as 41 miles
For 100-199 subtract 25 miles--so for 175 miles driven I
need it to show as
150 miles
Over 200 Subtract 0 miles-- so 225 as 225
Thanks!
--Ms Chewie
.
|