software

daysperdiemtotal
15050
250100
350125
450175

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

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(dayslt;=2, 50*days, (days-2)*50 75
quot;lisaquot; wrote:

gt; daysperdiemtotal
gt; 15050
gt; 250100
gt; 350125
gt; 450175
gt;
gt; my formula:
gt; =(B3*0.75)*(A3-2) (A3-2)*B3
gt;
gt; the per diem rate i am trying to get is for travel, the 1st and last day of
gt; travel is 75% of the per diem rate and the days in between are at 100%, i am
gt; trying to get this formula to calculate for 1, 2, and 3 or more days this
gt; formula only does it correctly for 3 or more days, 1 and 2 days of per diem
gt; is calculated at 75%, is this possible