IF Function

%3CLINGO-SUB%20id%3D%22lingo-sub-1277081%22%20slang%3D%22en-US%22%3EIF%20Function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1277081%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20working%20with%20Excel%20and%20I%20am%20facing%20one%20problem%20with%20function%20IF.%3C%2FP%3E%3CP%3EFor%20the%20fuction%20I%20wrote%20if%20b9%26gt%3B400000%3C%2FP%3E%3CP%3EFor%20true%20results%20%22B9*0.025%22%2C%20for%20all%20the%20true%20results%20I%20want%20the%20cell%20b9%20be%20multipled%20by%26nbsp%3B0.025%3C%2FP%3E%3CP%3EFor%20false%20results%20%22B9*0.015%22%26nbsp%3B%20for%20all%20the%20falseresults%20I%20want%20the%20cell%20b9%20be%20multipled%20by%26nbsp%3B0.015%3C%2FP%3E%3CP%3EThe%20problem%20is%20that%20instead%20of%20multiplying%20the%20cell%20b9%20by%20any%20numbers%20the%20fuction%20just%20writes%26nbsp%3B%22B9*0.025%22%20or%26nbsp%3B%20%22B9*0.015%22%20for%20true%20or%20false%20cases.%20How%20can%20I%20fix%20this%20problem%20so%20I%20will%20have%20the%20results%20of%20the%20multiplication%20instead%20of%20the%20equation%20in%20cells%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20help!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1277081%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1277554%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20Function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1277554%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F607141%22%20target%3D%22_blank%22%3E%40Zaharyshka8%3C%2FA%3E%26nbsp%3BJust%20remove%20the%20apostrophes%20%22%22.%20Then%20it%20will%20work.%20By%20using%20the%20%22-signs%20you%20tell%20Excel%20to%20display%20a%20text.%20It%20is%20no%20longer%20recognised%20as%20a%20formula.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1277869%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20Function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1277869%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F607141%22%20target%3D%22_blank%22%3E%40Zaharyshka8%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EJust%20in%20case%2C%20another%20variant%20could%20be%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-markup%22%3E%3CCODE%3E%3DB9*(1.5%2B(B9%26gt%3B400000))%2F100%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1283069%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20Function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1283069%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3BHey%2C%20I%20fixed%20it.%20Thank%20you%20for%20your%20help!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1283071%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20Function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1283071%22%20slang%3D%22en-US%22%3E%3CP%3EI%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3BI%20figured%20out%20where%20I%20have%20made%20a%20mistake.%20Thank%20you%20for%20your%20help!%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hello,

 

I am working with Excel and I am facing one problem with function IF.

For the fuction I wrote if b9>400000

For true results "B9*0.025", for all the true results I want the cell b9 be multipled by 0.025

For false results "B9*0.015"  for all the falseresults I want the cell b9 be multipled by 0.015

The problem is that instead of multiplying the cell b9 by any numbers the fuction just writes "B9*0.025" or  "B9*0.015" for true or false cases. How can I fix this problem so I will have the results of the multiplication instead of the equation in cells?

 

Thank you for your help!

 

 

4 Replies
Highlighted

@Zaharyshka8 Just remove the apostrophes "". Then it will work. By using the "-signs you tell Excel to display a text. It is no longer recognised as a formula.

Highlighted

@Zaharyshka8 

Just in case, another variant could be

=B9*(1.5+(B9>400000))/100
Highlighted

@Riny_van_Eekelen Hey, I fixed it. Thank you for your help!

Highlighted

I@Sergei Baklan I figured out where I have made a mistake. Thank you for your help!