+ Reply to Thread
Results 1 to 4 of 4

Quick formula question

  1. #1
    Registered User
    Join Date
    04-04-2012
    Location
    Provo, Utah
    MS-Off Ver
    2010
    Posts
    2

    Exclamation Quick formula question

    Hi. I'm trying to create a formula that for 2 adjacent cells, it takes a quarter of their combined value and adds it to another cell and divides the combined result from a fourth cell. What I thought would work is this: =SUM(((K2:L2/4)+M2)/S2). It's giving me a "#VALUE!" message. Can someone please let me know what I'm doing wrong? I've tried variations on this with differing amounts of () brackets, but to no avail. I'm an excel newbie and would be extremely grateful for any help.
    Last edited by slcphoto; 04-04-2012 at 05:44 PM.

  2. #2
    Forum Expert
    Join Date
    09-27-2011
    Location
    Poland
    MS-Off Ver
    Excel 2007
    Posts
    1,312

    Re: Quick formula question

    Hi
    you mean this?
    =(SUM(K2:L2)/4+M2)/S2
    Regards

    tom1977

    If You are satisfied with my solution click the small star icon on the left to say thanks.

  3. #3
    Registered User
    Join Date
    04-04-2012
    Location
    Provo, Utah
    MS-Off Ver
    2010
    Posts
    2

    Re: Quick formula question

    Oh wow. Fantastic. Thank you so much!

  4. #4
    Forum Expert Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,885

    Re: Quick formula question

    Hi SLCPhoto, welcome to the forum.

    In the future, please adhere to the forum rules and create threads with proper signatures (see Rule #1, link to rules in my signature below). In this instance, "Formula referencing multiple cells returning VALUE error" could work.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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