Adding 2 for every multiple of 5

  • Thread starter Thread starter MC0311bravo
  • Start date Start date
M

MC0311bravo

I'm trying to find a formula that will add 2 for each multiple of 5 for a
given cell.

Let's say the value of cell A1 is 15. I'm looking for a formula that will
determine that 15 is disable equally by 5 three times and add 6 (2 for each)
to the orinal value (15)

Help!
 
With a little algebra, your formula becomes....

=INT(A1/5)*7

But I am not entirely sure that is what the OP wants (his post is not really
clear)... what if the cell contained, say, 17... does he want to reduce it
to 15 (as you formula does) or just leave it be, like this formula does...

=A1+INT(A1/5)*2
 
Hi,

The general idea would be

=A1*7/5

however, if you want it multiplied only for whole divisions

=7*INT(A1/5)
 
Back
Top