MS Excel ( Help Line )

Discussion in 'Microsoft Excel' started by madnankn, Oct 29, 2005.

  1. Sunny Khan

    Sunny Khan New Member




    madnankn bhai i think is post ko 7 ya 8 months tou hogae hoongein


    Mashallah se sub kuch ata hai formala's bhe k c had tak atey hain liken kuch assey hain jo nahi bhe ho rahein hain


    dekhein time ka formala

    ager mein yeh time minus karna chahta hon is condition per


    (A1) 8:00
    (A2) 9:00
    =time(a1-a2) result yeh aa raha hai #####



    wase yeh minus ho jata hai
    9:00
    8:00
    liken oper wala nahi


    formala bataein is time k mutabik
     
  2. MUHAMMED ZAHEER

    MUHAMMED ZAHEER New Member

    Payment Sheet Me Kis Tarha Currency Denomination Maloom Karegaye

    `payment Sheet Me Kis Tarha Currency Denomination Maloom Karegaye
    Jesi
    1000 Ki Kitne Note
    500 Ki Kitne Note Etc
     
  3. Zaheer Abbas

    Zaheer Abbas New Member

    Pivot Table

    Yar pivot Table k baray main tafseel say batain
     
  4. wasim_akhter32

    wasim_akhter32 New Member

    Hum Ko Ek problem hai Iss ka koi hal hai to batana Mana ke main kisi Column main 37 (Column "A") likhta hoon to uss ka zor kuch iss tarah se dusre column main aa jaye 3+7=10 to dusre column main 10 ana chayiye (Column "B") main main aap sabhi ka sukur guzar
     
  5. faizan351

    faizan351 New Member

    I want to know that if in excel a1 value is 1 and a2 value is 2 and a3 valu is 3 and a4 value is 4 and a5 value is 5 then i apply formula in b1 =a5 and drag formula it gives b2=a6 and b3=a7 and b4=a8 simulataneously but i want it go reverse i mean it go b2=a4 and b3=a3 like this.I know that i can apply in b column in every cell separate formula but i want to achieve my purpose with draging of formula to save time.Can any body help me about this?
     
  6. meerzaali

    meerzaali New Member

    PLZ Help

    AOA,


    Bhai Excel mai combo box mai value kis tarah daley gay or her value per link kis trah select karrey gay.........
     
  7. aansootear

    aansootear New Member

  8. mabdullah

    mabdullah New Member

    "Excell problem"

    Aslam-o-Alaikum,
    Bhai Jan mere Computer mein aik buhat serious masla aaya hai.Main ne apne total mobile no. aur dostri information M.S.Excel mein save ke thein.
    Main ne 2 month tak is file ko open nahin kia, lakin aub yeh file open nahin hoti. Jub main file open kerta hoon to us ke language change hoti hai aur screen per machine language mein box aur pata nahin kia likha huwa aata hai.


    PLS Help Me.
    I shell be very thankfull to you.
     
  9. mabdullah

    mabdullah New Member

    sadiq189@yahoo.com
     
  10. fbaig

    fbaig New Member

    wasae personally mujae excel sae bohat sae issuess hane...agarchae use bhi kafi hae.
     
  11. Mian_jani

    Mian_jani Member

    Vlooup?????

    I wanna know about VLOOKUP.Plz tell me in deatil.
     
  12. adilkhan

    adilkhan New Member

    salam
    Excel ki File nahi kul rahi.File Conversion Problem ha is masla ka kia
    hal ho ga.
    plz plz plz plz plz
     
  13. adilkhan

    adilkhan New Member

    Office dobara install karna sa be conversion ka problem hal nahi hota
     
  14. majoowell

    majoowell New Member

    excel password

    :confused: hello aslam alaikum

    yaar main urdupages ka new member hoon. or aap sab say aik
    help ka talabgar hoon. or wo yeh kay mere ms excel ki file ko password laga howa hai or main ab password bhool giya hoon. tutorial section
    main aik thread parh kar password break karnay ki koshish ki lakin sub bekar
    kiyon kay os software say file open nahi hoi. plz aap logon kay pass is ka koi hal ho to plz mujhay bata dain. aap ki madad ka talabgar majoowell


    <majoowell@yahoo.co.in>
     
  15. Afsheen

    Afsheen New Member

    hi bhai meri aik prob hai plz bata dijiye
    problem yeh hai k selery sheet nikalne k liye jo formulas apply karnay hain mujhay woh formula's nahi aatay..jesay k worker ki aik din ki selery ko nikalnay k liye kon sa formula apply hoga plz tell me:)
     
  16. Ali Rashid

    Ali Rashid New Member

    is it possible...?

    Asalam o Aliakum

    kiya ye mumkin hai Excel mien k figure ko Word mien tabdeel kiya jaasake like
    45,140=(Forty Five Thousand One Hundred Forty) ager hai tu kaisey....

    Plz Help me

    Regards
    Ali
     
  17. poison

    poison New Member

    Salamm bhai jaan mery thoriii sy help kerain.....

    mein ne aik sheet taiyaar kernii ha jiss mein 4 colomn hain

    1- Sr No
    2- Question
    3- Answer
    4- Marks

    :confused: no2 mein aik sawall hai aur no3 mein uss ka answer true or false mein type kerna hai ager question walay portion mein condition true ha aur iss ka answer true ha tu iss ky value no4 mein 1 print hoo aur ager false likha jai gy tu iss ky value 0 print hooo:confused:
     
    Last edited: Jul 26, 2007
  18. Mian_jani

    Mian_jani Member



    Paa G Marks walay Sell main ye Formula Lekhain =if(Answer walay sell ka adress=true,1,0) e-g Answer walay sell ka Adress uger C3 hay tu Formula is Tarha ho ga =if(C3=true,1,0) Lo g ap ka Kam Tamam ho geya.:)
     
  19. Mian_jani

    Mian_jani Member




    Aik din ki salary Nikalnay k lee
    Total salary ko Month days per Divide kar do
    e-g Ap ki salary 5000 hay or month main din atay hain 30
    tu ap =5000/30 kar dain ap ki ik din ki salary nikal aye gi.
     
  20. Mian_jani

    Mian_jani Member

    Paa g ap A1 main 37 lekhain or B1 main ye formula Lekhain =(A1*0.1-TRUNC(A1*0.1))*10+(TRUNC(A1*0.1)) samjhain ap ka kam Tamam ho geya.
     

Share This Page