#1
|
|||
|
|||
Formula Creation
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? Last edited by lahanroyal; 07-24-2019 at 10:13 PM. |
#2
|
||||
|
||||
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 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) |
#3
|
|||
|
|||
how do we put them in brackets?
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. |
#4
|
||||
|
||||
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)&" )" |
Tags |
calculate, formula |
Thread Tools | |
Display Modes | |
|
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 |