Forum Discussion
JSzym
Sep 02, 2021Copper Contributor
Need help with an "IF" function for a yes/no answer
I'm trying to create an "IF" statement where...
If there is a "Y" in cell E44, then Excel should multiply the value in cell C44 by 1 (for 100% of that value).
If there is a "N" in cell E44, then Excel should respond with a 0.00.
An example of what I'm trying to do. If a business a specific goal of over 90% for their lead management, their manager will put a "Y" in a specific cell. I then need Excel to see that a yes there would lead to that person receiving 100% of the bonus dollar amount listed in another cell. However, if they did not achieve that goal and a "N" is in that specific cell, then they do not earn that portion of the bonus and a "0.00" should be entered for their bonus.
2 Replies
- JSzymCopper ContributorAh! Geez, I've been sitting here for 30 minutes cursing at this computer haha. Thank you, Hans! Still learning.