Numbers (the app) help.

Discussion in 'Mac Apps and Mac App Store' started by skinnylegs, Feb 13, 2009.

  1. skinnylegs macrumors 65816

    skinnylegs

    Joined:
    May 8, 2006
    Location:
    San Diego
    #1
    I am using numbers for my accounts receivable. I have a formula which some dude created for me *years* ago that I used in Claris Works and it *seems* to work most of the time in Numbers. Anyway, the formula provides for either a debit or a credit and a balance.

    This is how it normally looks.....

    However, for some weird reason the balance gets all screwed up whenever I enter cents into the equation.

    Check this out. I entered 5192 in the credit section and it changed the balance accordingly.....

    However, when I add the 70 cents (.70) to the credit, the balance looks all messed up.....

    It must be something I'm doing or not doing. It always is. LOL Any help would be greatly appreciated.
     

    Attached Files:

  2. skinnylegs thread starter macrumors 65816

    skinnylegs

    Joined:
    May 8, 2006
    Location:
    San Diego
    #3
    =if(and(isblank(c3),isblank(d3)),"",e2+(d3-c3))
     

Share This Page