Thread: [Solved] Formula Creation
View Single Post
 
Old 07-24-2019, 11:37 PM
Marcia's Avatar
Marcia Marcia is offline Windows 7 32bit Office 2013
Expert
  
Join Date: May 2018
Location: Philippines
Posts: 553
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default
Try
="("&INT(A1*0.05)&"-"&INT(MOD(A1*0.05,1)*20)&"-"&INT(MOD(MOD(A1*0.05,1)*20,1)*20)&"-"&ROUND(MOD(MOD(MOD(A1*0.05,1)*20,1)*20,1)*16,1)&" )"
Reply With Quote