Sep 02 2021 12:22 PM
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.
Sep 02 2021 12:29 PM - edited Sep 02 2021 12:30 PM
SolutionSep 02 2021 12:32 PM
Sep 02 2021 12:29 PM - edited Sep 02 2021 12:30 PM
Solution