Thread: [Solved] Formula Creation
View Single Post
 
Old 07-24-2019, 07:42 AM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2016
Expert
 
Join Date: Apr 2014
Posts: 948
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default

If your value of 25.53 Katha is in cell A1, then in any other cell:
Code:
=INT(A1*0.05) & "-" & INT(MOD(A1*0.05,1)*20) & "-" & ROUND(MOD(MOD(A1*0.05,1)*20,1)*20,2) & "-" & 0
will give: 1-5-10.6-0
and this:
Code:
=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)
will give: 1-5-10-9.6
Reply With Quote