Results 1 to 17 of 17

Help with bank account formula

Threaded View

  1. #11
    Registered User
    Join Date
    04-06-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    11

    Re: Help with bank account formula

    Quote Originally Posted by etaf View Post
    do not use the + sign in the sum - that will give errors

    use
    =SUM(B1,C15)

    then you will get B1 value , even if C15 is blank - is that what you wanted
    Ok, i did this new sheet based on what i want, this is how i had it when i began.
    what i want this spreadsheet to do now is not show the values $0.00 when nothing is inserted.

    i was able to do it before using the function IF, but it messed up the rest of the formulas, so now i came back to what i had to see if someone can find a easier way to fix this problem.

    it seems like such an easy solution, but i can't get my head around it.

    thanks.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1