View Single Post
  #1   Report Post  
spannerhappy
 
Posts: n/a
Default 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