+ Reply to Thread
Results 1 to 2 of 2

IF Formula with Sum inside?

  1. #1
    Registered User
    Join Date
    06-30-2016
    Location
    Kettering, UK
    MS-Off Ver
    Office 365
    Posts
    25

    IF Formula with Sum inside?

    Having a moment & can't work out if I'm doing something wrong or it isn't supported.

    I'm trying to make an if formula based on if a target has been met, example below rather than a sheet.

    A1 will hold the target & B1 will hold the value. In C1, I want the formula to generate based on the below.

    Greater than A1 then "Achieving"
    Less than A1 minus 10 then "Under"
    Less than A1, but greater than A1 minus 10 "Improvement"

    Hope that makes sense & hopefully the solution isn't staring me straight in the face.

  2. #2
    Forum Guru HansDouwe's Avatar
    Join Date
    06-21-2022
    Location
    Nederland
    MS-Off Ver
    365 V2403 (Build 17330.20000)
    Posts
    6,461

    Re: IF Formula with Sum inside?

    Please try in C1:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. INDIRECT/ADDRESS inside LINEST function versus inside INTERCEPT
    By slny06 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-14-2019, 08:51 AM
  2. [SOLVED] formula to extract max range used inside another formula and display in another cell
    By AndyJr in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-04-2018, 11:33 AM
  3. Combobox inside a multipage inside a frame on a worksheet
    By Ploos in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-09-2017, 09:03 AM
  4. ROW() inside OFFSET() inside IF() not expanding array always!
    By tralston in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-23-2016, 01:19 PM
  5. [SOLVED] How to restrict pop of message box inside multiple times when it is inside a for loop?
    By timmu in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-26-2014, 06:00 AM
  6. Replies: 1
    Last Post: 10-02-2012, 04:27 PM
  7. [SOLVED] external link reference formula inside formula user input
    By jscc in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-20-2012, 04:29 PM

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