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

Goal Seeking via Excel 0
Finding the right style field in VBA 0
create manufacturing demand based on customer delivery 0
Help with lots of formulas 3
convert time to decimal 2
Lookup in multiple & separate cells 6
lookup two different variables 0
Look Up Multiple Values And Returning One Value 3

Top