Forum Discussion

Zaharyshka8's avatar
Zaharyshka8
Copper Contributor
Apr 02, 2020

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

Resources