Hiya all,
I am hope someone can help me out. I am trying to redo my travel expense
sheet on to excel to save time. So here is my problem, if I travel 148 miles
in one day the first 100miles are at a rate of £0.40p/m and anything above
100miles (48miles) is at a rate of £0.25
I want to input the 148miles into one cell and use a formula to
automatically fill in the two required cells, is this possible? (as I am not
allowed to change the layout of the expense sheet) I have the formulas done
for each rate. I just need to put the right mileage into the different cells.
I have the expense sheet on two sheets on excel because I cant turn one
page into landscape while keeping sheet 1 as portrait. Is there another way?
Or can I copy excel to word keeping the formulas? To make it easier to print
when finished?
Thank you for the time reading this and I hope you can help. Please take it
easy on me as I am not use to excel.
Celtic Charmer.