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!
Bookmarks