Good morning,

I have a travel expense form that I created (very simplistic) I have set the
Total Private Vehicle Miles traveled to "0" for then number so when you enter a number such as 10.5 it shows 11. Then when the person types into that field 10.5, the next column (rate per mile) has this calculation =IF(M30>=1,0.56,"") then the third column has this calculation (Reimbursed PMV) =IF(M31>=1,((M31-O31)*P31),"") does the math and we get the total.

However, since I'm not that experienced in excel I found that it actually wasn't calculating correctly like I thought. It was using the data entered 10.5 instead of 11 and not rounding up.

I'm sure it's something simple, but when I input round and try that it gives me an error message. I have several rows for people to input multiple travel miles but didn't but it all in.

Any Help would be appreciated. I can also send the spreadsheet I have created for someone to look at. Thank you.

Rosie