validation?

  • Thread starter Thread starter reading2004
  • Start date Start date
R

reading2004

I'm creating a spreadsheet to work out how much travel costs i need t
calculate for a certian number of trips per year.
i have my main cell stating how many months a person works. this perso
is only allowed a trip after every 4 months worked. so in this case,
trips per year.

i need to make a calculation that will multiply the number of trips pe
year by the cost of a flight, which in this case is 2,500.

however, the problem i am having , is that if the person works 6 month
he is still only eligible for one flight. and my calculations, multipl
the flight cost (2,500) by 1.5 (one and a half trips). how can
overcome this problem?
 
Hi

with number of months in A1 the following formula should give you the
correct number of trips eligble for:
=FLOOR(A1/4,1)

Cheers
JulieD
 
try to mutliply with this formula

d1 = months he has been working till now

ROUNDDOWN(D1/4,0)
 
With the number of months per trip in cell G1, and months worked in cell
B2, enter the following formula in cell C2:

=INT(B2/$G$1)

Copy down to the last row of data, and use this number in the flight
cost calculations.
 
Back
Top