+ Reply to Thread
Results 1 to 2 of 2

IF formula needed to only show answer when number entered into another cell.

  1. #1
    Forum Contributor
    Join Date
    07-06-2013
    Location
    USA
    MS-Off Ver
    MS Office 2019 Pro Plus
    Posts
    182

    IF formula needed to only show answer when number entered into another cell.

    Please see attached WS

    I currently have a formula in N6:N1005 that calculates a sales commission based on multiple percentage levels of the commission offered.
    Basically, the commission is calculated as a percentage on the 1st $100,000 of the sales price (L6:L1005) and then another percentage on the balance (M6:M1005).
    In my spreadsheet the sales price is F6:F1005.
    The problem is, when I do not enter a sales price into F6:F1005, a negative number appears in N6:N1005 which I do not want (see N7).
    I simply do not want the formula to calculate in N6:N1005 until an amount is entered into F6:F1005.
    Please help, thank you.
    Attached Files Attached Files

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,916

    Re: IF formula needed to only show answer when number entered into another cell.

    In N6:

    =IF(F6="","",your_formula)
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

+ 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. [SOLVED] Formula needed to not show neg number when calculating totals from other cells
    By excelteam777 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-12-2017, 12:27 PM
  2. Formula needed to populate associate name when ID number entered in another cell
    By excelteam777 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-20-2013, 12:06 AM
  3. Formula Needed to match 2 ranges of data and populate cell with answer
    By ZanPal in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 06-08-2013, 08:19 AM
  4. Replies: 3
    Last Post: 10-27-2009, 03:51 PM
  5. VBA to show certain text when a number is entered into a cell
    By jiminic in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-01-2008, 12:34 AM
  6. [SOLVED] can excel show only the answer to a formula in the cell
    By pmms in forum Excel General
    Replies: 3
    Last Post: 08-03-2006, 12:35 PM
  7. numbers being entered show in formula bar but not in cell?
    By Jim in Florida in forum Excel General
    Replies: 2
    Last Post: 05-13-2005, 02:06 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