IF Function

[Zaharyshka8]

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!

[#2]

@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.

[#3]

@Zaharyshka8 

Just in case, another variant could be

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

[#4]

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

[#5]

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