Results 1 to 7 of 7

Thread: Convert Dozens into Pieces.

  1. #1
    Sohailattari is offline Junior Member
    Last Online
    14th November 2015 @ 01:14 AM
    Join Date
    22 May 2007
    Age
    51
    Posts
    12
    Threads
    5
    Credits
    0
    Thanked
    0

    Default Convert Dozens into Pieces.

    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
    Attached Files Attached Files

  2. #2
    robostic is offline Senior Member+
    Last Online
    23rd August 2016 @ 07:33 PM
    Join Date
    19 May 2009
    Location
    Somewhere Around
    Age
    41
    Posts
    1,581
    Threads
    105
    Credits
    840
    Thanked
    16

    Default

    Yeh Lo File download kar kai check karlo
    Attached Files Attached Files

  3. #3
    djdanish is offline Member
    Last Online
    8th May 2010 @ 09:40 PM
    Join Date
    01 Dec 2009
    Age
    35
    Posts
    1
    Threads
    0
    Thanked
    0

    Default dear

    i also dont know.sorry

  4. #4
    Sohailattari is offline Junior Member
    Last Online
    14th November 2015 @ 01:14 AM
    Join Date
    22 May 2007
    Age
    51
    Posts
    12
    Threads
    5
    Credits
    0
    Thanked
    0

    Default

    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::
    Attached Files Attached Files

  5. #5
    syar is offline Advance Member
    Last Online
    14th March 2024 @ 07:49 PM
    Join Date
    31 Jul 2009
    Location
    Nowshera(KP)
    Age
    47
    Gender
    Male
    Posts
    882
    Threads
    9
    Credits
    548
    Thanked
    340

    Default



    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?

  6. #6
    Sohailattari is offline Junior Member
    Last Online
    14th November 2015 @ 01:14 AM
    Join Date
    22 May 2007
    Age
    51
    Posts
    12
    Threads
    5
    Credits
    0
    Thanked
    0

    Default convert karna hai pieces.


    Yes yes I want to this issue for solution.

    Thanks you.

  7. #7
    syar is offline Advance Member
    Last Online
    14th March 2024 @ 07:49 PM
    Join Date
    31 Jul 2009
    Location
    Nowshera(KP)
    Age
    47
    Gender
    Male
    Posts
    882
    Threads
    9
    Credits
    548
    Thanked
    340

    Default



    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
    Attached Files Attached Files

Similar Threads

  1. Expired ~* 570 Border Pieces For Designing *~
    By Fazli Quddus in forum Design Stuff
    Replies: 74
    Last Post: 29th October 2013, 09:03 AM
  2. 12 Fantastic Tiny Pieces of Art
    By Ahmed Khan in forum Photo Gallery
    Replies: 4
    Last Post: 29th July 2011, 10:02 PM
  3. Islamic decoration pieces
    By fayazdubai in forum Photo Gallery
    Replies: 14
    Last Post: 26th March 2011, 02:15 PM
  4. Master Pieces
    By shahid_iqbal in forum Photo Gallery
    Replies: 3
    Last Post: 15th July 2010, 12:22 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •