Formula Creation

lahanroyal · #1 07-24-2019, 12:48 AM

1 Bigha= 20 Katha 1 Katha=20 Dhoor 1 Dhoor= 16 Kanwa now suppose i have a value in Katha which is 25.53, I want the excel formula to calculate and give me this automatically (1-5-10.6-0)

I dont mind if the kanwa value is shown in dhoor itslef.
1 Dhoor=182.25 Sft.

Can anyone help me with this small excel formula creation?

p45cal · #2 07-24-2019, 07:42 AM

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

lahanroyal · #3 07-24-2019, 09:38 PM

The answer, suppose is, 1-5-10-9.6, I would want them to be in this format:
(1-5-10-9.6)
Could you help me get this?
The formula is working just perfect. Thanks bdw.

Marcia · #4 07-24-2019, 11:37 PM

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)&" )"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

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