Adding 2 for every multiple of 5
 

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!

Adding 2 for every multiple of 5
 

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


"MC0311bravo" wrote:

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!

Adding 2 for every multiple of 5
 

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

--
Rick (MVP - Excel)


"Teethless mama" wrote in message
...
=INT(A1/5)*2+INT(A1/5)*5


"MC0311bravo" wrote:

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!

Adding 2 for every multiple of 5
 

Hi,

The general idea would be

=A1*7/5

however, if you want it multiplied only for whole divisions

=7*INT(A1/5)

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"MC0311bravo" wrote:

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!

Adding 2 for every multiple of 5
 

Another...

=QUOTIENT(A1,5)*2+A1



"MC0311bravo" wrote:

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!