Forum Discussion

JSzym's avatar
JSzym
Copper Contributor
Sep 02, 2021
Solved

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

    • JSzym's avatar
      JSzym
      Copper Contributor
      Ah! Geez, I've been sitting here for 30 minutes cursing at this computer haha. Thank you, Hans! Still learning.

Resources