Results 1 to 4 of 4

Thread: رقم کو ہنسوں میں لکھنا

  1. #1
    anoman is offline Senior Member+
    Last Online
    9th March 2024 @ 10:34 AM
    Join Date
    07 Apr 2010
    Posts
    103
    Threads
    47
    Credits
    1,480
    Thanked
    0

    Default رقم کو ہنسوں میں لکھنا

    مجھے ایکسل کے فارمولے کی ضرورت ہے کہ اگر میں کوئی رقم ہندسوں میں لکھوں تو وہ دوسرے سیل میں لفظوں میں لکھی ہوئی آئے

  2. #2
    Join Date
    21 Dec 2008
    Location
    Faisalabad
    Age
    41
    Gender
    Male
    Posts
    2,588
    Threads
    104
    Credits
    4,372
    Thanked
    173

    Default

    apko eska add on install karna pary ga

  3. #3
    Join Date
    07 Dec 2009
    Location
    Kot addu
    Gender
    Male
    Posts
    1,267
    Threads
    202
    Credits
    579
    Thanked
    78

    Default

    =CHOOSE(LEFT(TEXT(B12,"000000000"))+1,,"One","Two" ,"Three","Four","Five","Six","Seven","Eight","Nine ")
    &IF(--LEFT(TEXT(B12,"000000000"))=0,,IF(AND(--MID(TEXT(B12,"000000000"),2,1)=0,--MID(TEXT(B12,"000000000"),3,1)=0)," Hundred"," Hundred and "))
    &CHOOSE(MID(TEXT(B12,"000000000"),2,1)+1,,,"Twe nty ","Thirty ","Forty ","Fifty ","Sixty ","Seventy ","Eighty ","Ninety ")
    &IF(--MID(TEXT(B12,"000000000"),2,1)<>1,CHOOSE(MID(TEXT( B12,"000000000"),3,1)+1,,"One","Two","Three","Four ","Five","Six","Seven","Eight","Nine"),CHOOSE(MID( TEXT(B12,"000000000"),3,1)+1,"Ten","Eleven","Twelv e","Thirteen","Fourteen","Fifteen","Sixteen","Seve nteen","Eighteen","Nineteen"))
    &IF((--LEFT(TEXT(B12,"000000000"))+MID(TEXT(B12,"00000000 0"),2,1)+MID(TEXT(B12,"000000000"),3,1))=0,,IF(AND ((--MID(TEXT(B12,"000000000"),4,1)+MID(TEXT(B12,"00000 0000"),5,1)+MID(TEXT(B12,"000000000"),6,1)+MID(TEX T(B12,"000000000"),7,1))=0,(--MID(TEXT(B12,"000000000"),8,1)+RIGHT(TEXT(B12,"000 000000")))>0)," Million and "," Million "))
    &CHOOSE(MID(TEXT(B12,"000000000"),4,1)+1,,"One","T wo","Three","Four","Five","Six","Seven","Eight","N ine")
    &IF(--MID(TEXT(B12,"000000000"),4,1)=0,,IF(AND(--MID(TEXT(B12,"000000000"),5,1)=0,--MID(TEXT(B12,"000000000"),6,1)=0)," Hundred"," Hundred and "))
    &CHOOSE(MID(TEXT(B12,"000000000"),5,1)+1,,,"Twenty ","Thirty","Forty","Fifty","Sixty","Seventy","Eigh ty","Ninety")
    &IF(--MID(TEXT(B12,"000000000"),5,1)<>1,CHOOSE(MID(TEXT( B12,"000000000"),6,1)+1,," One"," Two"," Three"," Four"," Five"," Six"," Seven"," Eight"," Nine"),CHOOSE(MID(TEXT(B12,"000000000"),6,1)+1," Ten"," Eleven"," Twelve"," Thirteen"," Fourteen"," Fifteen"," Sixteen"," Seventeen"," Eighteen"," Nineteen"))
    &IF((--MID(TEXT(B12,"000000000"),4,1)+MID(TEXT(B12,"00000 0000"),5,1)+MID(TEXT(B12,"000000000"),6,1))=0,,IF( OR((--MID(TEXT(B12,"000000000"),7,1)+MID(TEXT(B12,"00000 0000"),8,1)+RIGHT(TEXT(B12,"000000000")))=0,--MID(TEXT(B12,"000000000"),7,1)<>0)," Thousand "," Thousand and "))
    &CHOOSE(MID(TEXT(B12,"000000000"),7,1)+1,,"One","T wo","Three","Four","Five","Six","Seven","Eight","N ine")
    &IF(--MID(TEXT(B12,"000000000"),7,1)=0,,IF(AND(--MID(TEXT(B12,"000000000"),8,1)=0,--RIGHT(TEXT(B12,"000000000"))=0)," Hundred "," Hundred and "))&
    CHOOSE(MID(TEXT(B12,"000000000"),8,1)+1,,,"Twenty ","Thirty ","Forty ","Fifty ","Sixty ","Seventy ","Eighty ","Ninety ")
    &IF(--MID(TEXT(B12,"000000000"),8,1)<>1,CHOOSE(RIGHT(TEX T(B12,"000000000"))+1,,"One","Two","Three","Four", "Five","Six","Seven","Eight","Nine"),CHOOSE(RIGHT( TEXT(B12,"000000000"))+1,"Ten","Eleven","Twelve"," Thirteen","Fourteen","Fifteen","Sixteen","Seventee n","Eighteen","Nineteen"))
    جہاں جہاں (بی 12) آرہا ہے اسکو اپنے اس سیل سے تبدیل کریں جہاں آپ نے ہندسے لکھے ہوئے ہیں شکریہ
    Attached Files Attached Files

  4. #4
    anoman is offline Senior Member+
    Last Online
    9th March 2024 @ 10:34 AM
    Join Date
    07 Apr 2010
    Posts
    103
    Threads
    47
    Credits
    1,480
    Thanked
    0

    Default

    #mtariqtsk
    بہت بہت شکریہ ۔۔۔۔ لیکن یہ تو بہت لمبا کلیہ ہے ۔۔۔۔۔ اس کو جب میں کاپی کر کے پیسٹ کرتا ہوں تو وہاں ایرر دیتا ہے۔۔۔۔ میں سیل نمبر بھی تبدیل کر رہا ہوں

Similar Threads

  1. Replies: 8
    Last Post: 26th February 2016, 02:12 PM
  2. Replies: 5
    Last Post: 25th January 2015, 03:32 PM
  3. Replies: 13
    Last Post: 5th October 2012, 08:41 PM
  4. Replies: 14
    Last Post: 17th December 2011, 12:51 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
  •