View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MC0311bravo MC0311bravo is offline
external usenet poster
 
Posts: 1
Default 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!