LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Ms Chewie
 
Posts: n/a
Default Subtracting based on number of miles

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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Seed numbers for random number generation, uniform distribution darebo Excel Discussion (Misc queries) 3 April 21st 23 09:02 PM
How to format a number in Indian style in Excel? Victor_alb Excel Discussion (Misc queries) 2 December 21st 04 04:21 AM
Count number of shaded cells Maddoktor Excel Discussion (Misc queries) 2 December 20th 04 08:35 PM
formula based on format James Kendall Excel Discussion (Misc queries) 4 December 16th 04 04:47 PM
Use Julian Date To Create Serial Number antho10359 Excel Discussion (Misc queries) 4 December 9th 04 01:50 AM


All times are GMT +1. The time now is 11:52 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"