Forum Discussion
Zaharyshka8
Apr 02, 2020Copper 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 mul...
Riny_van_Eekelen
Apr 03, 2020Platinum 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.
Zaharyshka8
Apr 05, 2020Copper Contributor
Riny_van_Eekelen Hey, I fixed it. Thank you for your help!