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