SOLVED

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

%3CLINGO-SUB%20id%3D%22lingo-sub-2713161%22%20slang%3D%22en-US%22%3ENeed%20help%20with%20an%20%22IF%22%20function%20for%20a%20yes%2Fno%20answer%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2713161%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20trying%20to%20create%20an%20%22IF%22%20statement%20where...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20there%20is%20a%20%22Y%22%20in%20cell%20E44%2C%20then%20Excel%20should%20multiply%20the%20value%20in%20cell%20C44%20by%201%20(for%20100%25%20of%20that%20value).%3CBR%20%2F%3EIf%20there%20is%20a%20%22N%22%20in%20cell%20E44%2C%20then%20Excel%20should%20respond%20with%20a%200.00.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAn%20example%20of%20what%20I'm%20trying%20to%20do.%26nbsp%3B%20If%20a%20business%20a%20specific%20goal%20of%20over%2090%25%20for%20their%20lead%20management%2C%20their%20manager%20will%20put%20a%20%22Y%22%20in%20a%20specific%20cell.%26nbsp%3B%20I%20then%20need%20Excel%20to%20see%20that%20a%20yes%20there%20would%20lead%20to%20that%20person%20receiving%20100%25%20of%20the%20bonus%20dollar%20amount%20listed%20in%20another%20cell.%26nbsp%3B%20However%2C%20if%20they%20did%20not%20achieve%20that%20goal%20and%20a%20%22N%22%20is%20in%20that%20specific%20cell%2C%20then%20they%20do%20not%20earn%20that%20portion%20of%20the%20bonus%20and%20a%20%220.00%22%20should%20be%20entered%20for%20their%20bonus.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2713161%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2713198%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20help%20with%20an%20%22IF%22%20function%20for%20a%20yes%2Fno%20answer%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2713198%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1096986%22%20target%3D%22_blank%22%3E%40JSzym%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIn%20F44%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3DIF(E44%3D%22Y%22%2CC44%2C0)%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EOr%2C%20without%20IF%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3D(E44%3D%22Y%22)*C44%3C%2FP%3E%3C%2FLINGO-BODY%3E
New 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 (New 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.