Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how do i set up a mileage allowance on excel.
i can't get my head around the if function!!
i get 0p for the first 15 miles then 19p for each mile after that up to 30 miles, then 29p per mile above that. I'm sure there is some clever person out there who can help Thanks |
#2
|
|||
|
|||
With your mileage in A1, try this:
=MAX(A1-30,0)*29+((A1-15)-MAX(A1-30,0))*19 15 mi = 0 16 mi = 19 30 mi = 19 31 mi = 29 -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "spannerhappy" wrote in message ... i can't get my head around the if function!! i get 0p for the first 15 miles then 19p for each mile after that up to 30 miles, then 29p per mile above that. I'm sure there is some clever person out there who can help Thanks |
#3
|
|||
|
|||
Thats Great
Thankyou Roland "RagDyeR" wrote: With your mileage in A1, try this: =MAX(A1-30,0)*29+((A1-15)-MAX(A1-30,0))*19 15 mi = 0 16 mi = 19 30 mi = 19 31 mi = 29 -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "spannerhappy" wrote in message ... i can't get my head around the if function!! i get 0p for the first 15 miles then 19p for each mile after that up to 30 miles, then 29p per mile above that. I'm sure there is some clever person out there who can help Thanks |
#4
|
|||
|
|||
Appreciate the feed-back.
-- Regards, RD -------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit! ------------------------------------------------------------------- "spannerhappy" wrote in message ... Thats Great Thankyou Roland "RagDyeR" wrote: With your mileage in A1, try this: =MAX(A1-30,0)*29+((A1-15)-MAX(A1-30,0))*19 15 mi = 0 16 mi = 19 30 mi = 19 31 mi = 29 -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "spannerhappy" wrote in message ... i can't get my head around the if function!! i get 0p for the first 15 miles then 19p for each mile after that up to 30 miles, then 29p per mile above that. I'm sure there is some clever person out there who can help Thanks |
#5
|
|||
|
|||
BUT ... It appears that both you and I didn't test for miles below 15.
This should return a "0", when A1 is less then 15: =MAX(A1-30,0)*29+(MAX(A1-15,0)-MAX(A1-30,0))*19 -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "RagDyer" wrote in message ... Appreciate the feed-back. -- Regards, RD -------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit! ------------------------------------------------------------------- "spannerhappy" wrote in message ... Thats Great Thankyou Roland "RagDyeR" wrote: With your mileage in A1, try this: =MAX(A1-30,0)*29+((A1-15)-MAX(A1-30,0))*19 15 mi = 0 16 mi = 19 30 mi = 19 31 mi = 29 -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "spannerhappy" wrote in message ... i can't get my head around the if function!! i get 0p for the first 15 miles then 19p for each mile after that up to 30 miles, then 29p per mile above that. I'm sure there is some clever person out there who can help Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
How do I isolate my Excel server (automation) from other Excel instances? | Excel Discussion (Misc queries) | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) | |||
sharing/using/saving Excel 2002 files in Excel 2003 | Excel Discussion (Misc queries) | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) |