SOLVED

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

Copper Contributor

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 (Copper Contributor)
Solution

@JSzym 

In F44:

 

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

 

Or, without IF:

 

=(E44="Y")*C44

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

Accepted Solutions
best response confirmed by JSzym (Copper Contributor)
Solution

@JSzym 

In F44:

 

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

 

Or, without IF:

 

=(E44="Y")*C44

View solution in original post