Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Formula Creation Formula Creation
Register FAQ

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #4  
Old 07-24-2019, 11:37 PM
Marcia's Avatar
Marcia Marcia is offline Formula Creation Windows 7 32bit Formula Creation 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
 

Tags
calculate, formula

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula Creation Report creation ecruz Word 1 03-21-2016 02:08 PM
Formula Creation Template creation Calvinclown Word 3 09-16-2014 07:19 PM
Formula Creation Document Creation Privateer Word 3 06-20-2013 08:15 PM
Formula Creation Label Creation speloquin Word 1 05-27-2011 03:08 PM
Report creation. Igtech Excel 1 04-02-2010 03:33 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:58 AM.

Contact Us - Privacy Statement - Top

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft