Excel වැඩක්_කරන්නෙ කොහොමද ?

001flyD

Well-known member
  • Oct 6, 2010
    9,800
    12,724
    113
    Mahanuwara
    Excel වැඩක්_කරන්නෙ කොහොමද ?

    Excel එකෙන් එක Input එකක් දාල (එක නම්බර් එකක්) සුත්‍ර 8 කින් හෝ ඉට වඩා ප්‍රමාණයකින් Output එක ගන්නෙ කොහොමද,සුත්‍ර 8 ටම එන X අගය එකමයි.ස්තුති :yes:
     

    ArunaTelshan

    Well-known member
  • Nov 29, 2013
    3,255
    1,216
    113
    Biyagama
    Godak diga ekaknam mokakhari function ekak thiyenawada balanna. nathnam Brackets use karalath puruwan.

    1st func - x+5
    2nd func - 1st func * 5 nam = (x+5)*5 wage
     
    • Like
    Reactions: 001flyD

    001flyD

    Well-known member
  • Oct 6, 2010
    9,800
    12,724
    113
    Mahanuwara
    Godak diga ekaknam mokakhari function ekak thiyenawada balanna. nathnam Brackets use karalath puruwan.

    1st func - x+5
    2nd func - 1st func * 5 nam = (x+5)*5 wage

    menna me wage formulas set ekak thiyenne machan

    T=(X×5) / 15
    D=(X×7)/ 12

    me set ekatama ena X agaya ekayi,mata X agaya witharak dala,set ekenma eka para out eka ganna one,eka karanne kohomada
     

    ArunaTelshan

    Well-known member
  • Nov 29, 2013
    3,255
    1,216
    113
    Biyagama
    menna me wage formulas set ekak thiyenne machan

    T=(X×5) / 15
    D=(X×7)/ 12

    me set ekatama ena X agaya ekayi,mata X agaya witharak dala,set ekenma eka para out eka ganna one,eka karanne kohomada


    A1 Cell ekata oyage value eka Input karanawa kiyala hithuwoth,
    me widiyata hadanne

    T=(A1×5) / 15
    D=(A1×7)/ 12
    etc...