Results 1 to 4 of 4

sum up to maximum value

Threaded View

  1. #1
    Registered User
    Join Date
    01-31-2022
    Location
    United States
    MS-Off Ver
    2020
    Posts
    2

    sum up to maximum value

    Good evening. I am relatively new to excel formulas and looking to understand how to get what is in my head into a workable formula.

    1. THE ISSUE
    The values in the "N" column represent the actual value that was entered.
    The values in the "O" column represent how much those values are increasing.

    The value in "P" is obviously the SUM of "N" and "O", which is fine, until it goes over the number "10" which I would like to set as a metaphorical "threshold".

    2. WHAT I WANT THE FORMULA TO SAY (I think)

    IF "P" exceeds "10.00," then round down to "10.00"

    OR

    IF "P" exceeds "10.00," then display "10.00"

    I DO NOT want it to affect any other values, only the "P" column

    How would I write this?
    Thanks!

    123.PNG
    Attached Images Attached Images
    Last edited by FDibbins; 01-31-2022 at 01:16 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. CUMIPMT calculation doesn't seem to match interest calculation from amortization table
    By cdub39 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 1
    Last Post: 11-28-2021, 08:11 PM
  2. Replies: 10
    Last Post: 07-22-2019, 06:27 AM
  3. [SOLVED] VBA to open a workbook with manual calculation and close with automatic calculation
    By thedunna in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-04-2019, 12:28 PM
  4. [SOLVED] Calculation of dates and leaving blank cell when calculation sees non-date values
    By Hedy in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-22-2018, 07:52 AM
  5. Replies: 0
    Last Post: 05-17-2014, 10:18 PM
  6. Replies: 1
    Last Post: 01-15-2013, 08:51 AM
  7. [SOLVED] Conditional statement calculation based on result of previous calculation.(Need some help)
    By takeprofit in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-01-2012, 01:45 AM

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