LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Another Greater Than Less Than onditional problem.

hey :) i'm having problems with my little issue of calculating mileage costs.

Basically I need to work out my mielage costs for a company i'm working for
who ask that i will need to work out 40cents per mile for first 10,000 miles,
then 25 cents thereafter. eventually adding the whole lot up for one lump sum

i'm not sure how to put that in formula form.

I managed the first half of it by multiplying the overall milage by 0.4. but
how do i get it to detect when the mileage has reached 10,000 in order for it
to recalculate at 0.25?
 
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
Greater and less than SUMSUE Excel Discussion (Misc queries) 4 July 10th 08 06:12 AM
Problem with Conditional Formatting and Greater than or equal too Amanda Excel Discussion (Misc queries) 1 May 29th 08 05:17 PM
I have Greater than, I need less than also rlee1999 Excel Worksheet Functions 3 December 12th 06 07:52 PM
Greater Than / Less Than Problem Mhz New Users to Excel 11 July 13th 06 08:10 PM
GREATER OR EQUAL TO BUT LESS THAN Problem using Sumproduct Ragdyer Excel Worksheet Functions 0 September 29th 05 05:39 AM


All times are GMT +1. The time now is 11:13 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"