+ Reply to Thread
Results 1 to 9 of 9

How to Calculate cells Only if another cell is Marked with the Letter "N"

  1. #1
    Registered User
    Join Date
    07-25-2017
    Location
    pleasan centre
    MS-Off Ver
    Not Sure
    Posts
    4

    How to Calculate cells Only if another cell is Marked with the Letter "N"

    UPDATED - Just Realized I missed an Important Cell.

    Hi All,

    Just joined.

    I'm trying to figure out how create a formula that will only calculate/turn on if the cell next to it is Marked with the Letter N.

    For Example:
    D6 - I will enter a percentage which is a discount
    E6 - The Cell I will enter in Y or N
    F6 - I will enter the Amount I Want to Discount
    G6 - Where I will put the formula that will calculate the Discount Amount.

    So,
    D6 - 15% (This will change Depending on the Transaction)
    E6 - N
    F6 - $100,000 (This will change Depending on the Transaction)
    G6 - $15,000

    If anything other than N is entered into E6, I don't want anything to calculate in G6

    Is this possible?

    Thanks in advance!
    Last edited by Brox; 07-25-2017 at 03:46 PM.

  2. #2
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,647

    Re: How to Calculate cells Only if another cell is Marked with the Letter "N"

    Try this...

    Please Login or Register  to view this content.
    Last edited by sktneer; 07-25-2017 at 03:11 PM. Reason: Forgot to include the cell reference
    Regards
    sktneer


    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.

  3. #3
    Forum Expert
    Join Date
    03-20-2015
    Location
    Primarily UK, sometimes NL
    MS-Off Ver
    Work: Office 365 / Home: Office 2010
    Posts
    2,404

    Re: How to Calculate cells Only if another cell is Marked with the Letter "N"

    Welcome to the forum.

    In H6:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    That's assuming that D6 is formatted as a percentage (i.e. 15% is actually 0.15) - if you have it entered as 15 instead, then use this:
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Hope that helps.
    Regards,
    Aardigspook

    I recently started a new job so am a bit busy and may not reply quickly. Sorry - it's not personal - I will reply eventually.
    If your problem is solved, please go to 'Thread Tools' above your first post and 'Mark this Thread as Solved'.
    If you use commas as your decimal separator (1,23 instead of 1.23) then please replace commas with semi-colons in your formulae.
    You don't need to give me rep if I helped, but a thank-you is nice.

  4. #4
    Valued Forum Contributor
    Join Date
    12-01-2016
    Location
    Planet Earth
    MS-Off Ver
    95 - 2016
    Posts
    343

    Re: How to Calculate cells Only if another cell is Marked with the Letter "N"

    Try This
    =IF(E6="N",G6-SUM(G6*D6),"")

  5. #5
    Registered User
    Join Date
    07-25-2017
    Location
    pleasan centre
    MS-Off Ver
    Not Sure
    Posts
    4

    Re: How to Calculate cells Only if another cell is Marked with the Letter "N"

    Quote Originally Posted by sktneer View Post
    Try this...

    Please Login or Register  to view this content.
    Thank you, this one worked. Only issue I see is that if I go from "N" back to "Y", the G7 still calculates. Is there any way to correct this?

    Thank you!

  6. #6
    Registered User
    Join Date
    07-25-2017
    Location
    pleasan centre
    MS-Off Ver
    Not Sure
    Posts
    4

    Re: How to Calculate cells Only if another cell is Marked with the Letter "N"

    Well, I just realized I missed an important cell and therefore the above formulas didn't work... so sorry but thank you for helping!

    Here is what I am trying to do:

    D6 - I will enter a percentage which is a discount
    E6 - The Cell I will enter in Y or N
    F6 - I will enter the Amount I Want to Discount
    G6 - Where I will put the formula that will calculate the Discount Amount.

    If anything other than N is entered into E6, I don't want anything to calculate in G6

    Thanks!

  7. #7
    Forum Expert
    Join Date
    03-20-2015
    Location
    Primarily UK, sometimes NL
    MS-Off Ver
    Work: Office 365 / Home: Office 2010
    Posts
    2,404

    Re: How to Calculate cells Only if another cell is Marked with the Letter "N"

    Okay, I thought you wanted the discounted amount, not the amount of discount.
    Use this:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  8. #8
    Registered User
    Join Date
    07-25-2017
    Location
    pleasan centre
    MS-Off Ver
    Not Sure
    Posts
    4

    Re: How to Calculate cells Only if another cell is Marked with the Letter "N"

    Quote Originally Posted by Aardigspook View Post
    Okay, I thought you wanted the discounted amount, not the amount of discount.
    Use this:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    THANK YOU!!! This worked perfectly! And makes total sense now that I see it written out. SAVED THE DAY! :-)

  9. #9
    Forum Expert
    Join Date
    03-20-2015
    Location
    Primarily UK, sometimes NL
    MS-Off Ver
    Work: Office 365 / Home: Office 2010
    Posts
    2,404

    Re: How to Calculate cells Only if another cell is Marked with the Letter "N"

    You're welcome, glad to be of help.

    If that takes care of your original question, then please take a moment to mark the thread as Solved so others know there's an answer here (instructions are in my sig). Thanks.

+ 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. Add date/time stamp to comment when cell is marked "X"
    By msaric in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 01-28-2016, 07:31 AM
  2. [SOLVED] IF a cell is marked, then copy row to "Master List"?
    By NCivitarese in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-14-2015, 04:35 PM
  3. [SOLVED] calculate the number of occurrences of a "Letter" based on a percentage
    By scottmcclean in forum Excel General
    Replies: 2
    Last Post: 07-27-2014, 12:07 PM
  4. [SOLVED] Generate Name Roster From Date Cells Marked "X"
    By rockytop80 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-10-2013, 02:54 PM
  5. Options marked with an "X" listed in a single cell separated by commas
    By jpecor2 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-13-2011, 02:06 PM
  6. Changing first letter to caps, letters after "-" and "/", and rest to small letter.
    By rhexis07 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-17-2008, 08:03 PM
  7. [SOLVED] create links to check boxes marked "good" fair"and "bad"
    By pjb in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-19-2006, 09:25 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