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!