+ Reply to Thread
Results 1 to 3 of 3

Need multiple formulas in single cell

  1. #1
    Registered User
    Join Date
    07-10-2009
    Location
    NY
    MS-Off Ver
    Excel 2000
    Posts
    2

    Need multiple formulas in single cell

    I'm trying to put these two formulas into a single cell.

    =IF(E3 < 1," "," ")

    F2-SUM(E1:E3)

    The first so that the cell will display (or at least look) blank if it's not retrieving any data.

    How could I combine these?

  2. #2
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,675

    Re: Need multiple formulas in single cell

    You could do something like this

    =IF(E3>0,F2-SUM(E1:E3),"")

    that returns a blank unless E3>0 in which case your calculation is triggered. If you expect numbers in all 4 cells you could also use a formula like:

    =IF(COUNT(F2,E1:E3)=4,F2-SUM(E1:E3),"")

  3. #3
    Registered User
    Join Date
    07-10-2009
    Location
    NY
    MS-Off Ver
    Excel 2000
    Posts
    2

    Re: Need multiple formulas in single cell

    Thank you very much for the quick reply!

    edit:

    First formula works perfectly. Awesome
    Last edited by Deltaeagle; 07-10-2009 at 09:06 AM.

+ Reply to Thread

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