Formula Creation

		Microsoft Office Forums > Microsoft Excel > Excel
Formula Creation

07-24-2019, 07:42 AM

p45cal

Windows 10 Formula Creation

Office 2016

Expert

Join Date: Apr 2014

Posts: 956

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

Tags

Other Forums: Access Forums

All times are GMT -7. The time now is 03:39 AM.