Results 1 to 6 of 6

if, then formula help for an unknown number

Threaded View

flopped.quads00 if, then formula help for an... 01-06-2012, 11:18 PM
teylyn Re: if, then formula help for... 01-06-2012, 11:35 PM
reachhari Re: if, then formula help for... 01-06-2012, 11:35 PM
teylyn Re: if, then formula help for... 01-06-2012, 11:38 PM
flopped.quads00 Re: if, then formula help for... 01-06-2012, 11:41 PM
reachhari Re: if, then formula help for... 01-06-2012, 11:44 PM
  1. #1
    Registered User
    Join Date
    01-06-2012
    Location
    tennessee
    MS-Off Ver
    Excel 2003
    Posts
    2

    if, then formula help for an unknown number

    i have a formula i cant figure out

    currently cells P4-P9 display $0.00 they are formulated to change as other cells are imputed. cell P13 displays $6,216 (and will stay that way).

    here is the problem

    on a monthly basis cells P4-P9 will change from $0.00 to a greater number, i want the new "greater" number of each cell plus the $6,216 from cell P13 to be totaled in cell P16, but if any of the P4-P9 cells still show a $0.00 i want that cell to be added with a default value of $2,429 so that cell P16 will show a projected amount only changing as actual monthly numbers are put into cell P4-P9

    budget.xlsx
    Last edited by flopped.quads00; 01-06-2012 at 11:22 PM.

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