| Home |
| Search |
| Today's Posts |
|
#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! |
| 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 | |||
Threaded Mode
