Forum Discussion
IF Function
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
- SergeiBaklanDiamond Contributor
- Zaharyshka8Copper Contributor
ISergeiBaklan I figured out where I have made a mistake. Thank you for your help!
- Riny_van_EekelenPlatinum Contributor
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.
- Zaharyshka8Copper Contributor
Riny_van_Eekelen Hey, I fixed it. Thank you for your help!