Calculating Per Diem Rates

[Guest]

days perdiem total
1 50 50
2 50 100
3 50 125
4 50 175

my formula:
=(B3*0.75)*(A3-2)+(A3-2)*B3

the per diem rate i am trying to get is for travel, the 1st and last day of
travel is 75% of the per diem rate and the days in between are at 100%, i am
trying to get this formula to calculate for 1, 2, and 3 or more days this
formula only does it correctly for 3 or more days, 1 and 2 days of per diem
is calculated at 75%, is this possible

 

[Guest]

Your statement doesn't match the table. If perdiem is 75% for the first day
of a trip, wouldn't a 1 day trip be at 75%, too? And wouldn't a 2 day trip
be 50*75%*2, or $75?

If so, then maybe:

=if(days=1,37.5,(days-2)*50+75)

If your table is correct, then

=if(days<=2, 50*days, (days-2)*50+75