Please help me for this function.
3-6,3.6 is answer 42.But I want to this convertions in excel by formula Please hurry up for this.
I will be thankful for this
Please help me for this function.
3-6,3.6 is answer 42.But I want to this convertions in excel by formula Please hurry up for this.
I will be thankful for this
i also dont know.sorry
I want this by formaula 3-6,3.6 is answer 42.and you send to me that I do very well but i should 3-6,3.6 by formula okkkkkkkkkkk.
Understand.
WSLM::
I have a question. What is your standard for input?
agar 3-6 ya 3.6 = 42 then
3.1 ya 3-1 = ? and
3.10 or 3-10 = ?
kion k agar 3.1 k matlab 37 aur 3.10 k matlab 46 tu excel k leye mushkil hoga k ye samajh sake.
Is leye aap ko input k leye standard banana hoga. please reply karain. If you are not sure tu kia main bana kar de sakta hon?
Yes yes I want to this issue for solution.
Thanks you.
Neeche deya gaya function/formula aap k dozen ko number m convert kare ga.
Standard will be
1.01 ya 1-01=13
1.10 ya 1-10=22
Aar cell A2 main 1.01 ya 1-01 lekha ho tu b2 m ye try karain.
=DOLLARDE(SUBSTITUTE(A2,"-","."),12)*12
Note:- Dollarde is part of Analyse toolpack function. Is k leye aap ko Tools--->add ins m ja kar anylase toolpack ko enable karna hoga.
And this function will convert numbers into dozen but into my standard.
=IF(B2-12<10,INT(B2/12)&" .0"&INT(B2-12),INT(B2/12)&". "&INT(MOD(B2,12)))
Agar koi baat pochne ho ya koi masla ho tu please let me know.
Also see attached file
Bookmarks