Adding 2 for every multiple of 5

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!
 
R

Rick Rothstein

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
 
S

Shane Devenshire

Hi,

The general idea would be

=A1*7/5

however, if you want it multiplied only for whole divisions

=7*INT(A1/5)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

convert time to decimal 2
Is there a way to parse multiple values in a cell and applycalculations to those cell ? 1
VLOOKUP - Multiple cells in lookup value 1
Summing multiple account #s in one cell, by referencing 4
If date is in the month of Sept, then "1", otherwise "2" 5
Nested If Statements 7
Complex 2 table formula 4
Search a column for values, return a value from adj column 2

Top