I want to create a spreadsheet that will total x number of mileages then multiply the first (up to)10,000 by .45 and everything over 10,000 by .25.

Can anyone help me please?

From your description what you appear to want is a conditional statement in the cell where you want the result e.g.

=IF(A1 <=10000,A1*0.45,A1*0.25)

where A1 is the cell you wish to evaluate.

__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com

Please add an example worksheet in future so we dont have to waste time recreating data that might be incorrect

try =IF(F12>10000,(10000*0.45)+((F12-10000)*0.25),F12*0.45)

I think that's exactly the solution I'm looking for. Thank you very much

Your advice to attach a spreadsheet is noted thank you