Dismiss Notice
You are browsing this site as a guest. It takes 2 minutes to CREATE AN ACCOUNT and less than 1 minute to LOGIN

Msaada wa Excel functions

Discussion in 'Tech, Gadgets & Science Forum' started by Kiresua, May 16, 2011.

  1. Kiresua

    Kiresua JF-Expert Member

    #1
    May 16, 2011
    Joined: May 13, 2009
    Messages: 1,195
    Likes Received: 16
    Trophy Points: 135
    Wana taaluma ya IT JF,

    Wasaalam, nimeandaa tool moja kwenye excel kwa ajili ya matumizi ya kifedha, sasa nimecreate collum inayoonyesha kama utazidisha matumizi basi matokeo ni kuwa jibu litakuwa negative, yaani ovespending. sasa wataalam shida yangu ni kuwa ninahitaji kujua namna ya kukomand kila cell kwenye hiyo collum ikiwa negative basi ionyeshe kwa rangi nyekundu (kuonyesha alam fulani hivi)

    Ninatumia excel 2007, ninaweza pia kuswitch kwenda kwenye excel 2003 kama kunauhitaji huo

    Asanteni kwa msaada wenu!!
     
  2. Kichwa Ngumu

    Kichwa Ngumu JF-Expert Member

    #2
    May 16, 2011
    Joined: Nov 6, 2010
    Messages: 1,707
    Likes Received: 25
    Trophy Points: 145
    Highlight cell unazotaka pawe na jibu, then right click, select Format Cells, kwenye tool bar select number, then select currency, there you can choose type of currency you are using (You may also choose none if the currency you prefer is not there) then utaona kuna numbers in black and red select numbers in red but not in blacket.
    maelezo tu ndio marefu lakini sio kazi kivile
     
  3. Kiresua

    Kiresua JF-Expert Member

    #3
    May 16, 2011
    Joined: May 13, 2009
    Messages: 1,195
    Likes Received: 16
    Trophy Points: 135
    Genious Kichwa ngumu!! thats brilliant so simple like that, kweli hii ni jF, tapata kila k2
     
  4. Kichwa Ngumu

    Kichwa Ngumu JF-Expert Member

    #4
    May 16, 2011
    Joined: Nov 6, 2010
    Messages: 1,707
    Likes Received: 25
    Trophy Points: 145
    Nipe thanks basi siunaona hapo ipo moja tu
     
Loading...