+ Reply to Thread
Results 1 to 2 of 2

possible to simplify?

  1. 02-23-2009, 03:20 AM #1
    xLiquidFlames
    xLiquidFlames is offline
    Registered User
    Join Date
    02-23-2009
    Location
    Florida, US
    MS-Off Ver
    Excel 2003
    Posts
    1

    possible to simplify?

    Hey folks,
    I am kind of a newb to Excel. I have come up with this formula that works (I was really supprised when I hit enter and it actually worked) but I was wondering if theres any way to simplify it..

    Please Login or Register  to view this content.
    Basically it checks E3 to make sure something is there AND that E4 through E27 are blank... if those two conditions are met then D3 becomes the output... otherwise and error (nothing follows) is given.

    Is there som way to shorten this for the blank cells? something like ..

    Please Login or Register  to view this content.
    I have tried doing that but it just says NAME? in the cell when I hit enter... is this the right format or is there an easier way to do what I want?

    Thanks,
    -LF
    Reply With QuoteRegister To Reply
  2. 02-23-2009, 03:29 AM #2
    JBeaucaire
    JBeaucaire is offline
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: possible to simplify?

    Your second formula will work if you press CTRL-SHIFT-ENTER to activate an array in that cell. Enter the formula, the press CSE instead of just ENTER, and it will work. You'll see braces { } appear around your formula.

    Or, this regular formula will do it as well if the values in E4:E27 are numeric:

    =IF(AND(E3<>"",SUM(E4:E27)=0),D3,"NOTHING FOLLOWS")
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1