Thread: Adding 2 for every multiple of 5
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default 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!
Reply With QuoteReply With Quote