Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple lookup values and adding multiple rates across together | Excel Worksheet Functions | |||
Adding multiple worksheets | Excel Worksheet Functions | |||
Adding multiple vlookups | Excel Worksheet Functions | |||
adding off of multiple sheets | Excel Discussion (Misc queries) | |||
adding certain cells in multiple worksheets in multiple workbooks | Excel Worksheet Functions |