SOLVED

New 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
best response confirmed by JSzym (New Contributor)
Solution

Re: Need help with an "IF" function for a yes/no answer

In F44:

=IF(E44="Y",C44,0)

Or, without IF:

=(E44="Y")*C44

Re: Need help with an "IF" function for a yes/no answer

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