Highlighted
New Contributor

# 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?

4 Replies
Highlighted

# Re: IF Function

@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

# Re: IF Function

Just in case, another variant could be

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

# Re: IF Function

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

Highlighted

# Re: IF Function

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