Feb 27 2022 07:58 AM
I am trying to use an If/Then formula to calculate a value. I'm using this: =IF(A8< 5000.01,C8=A8*0.05).
The cell that contains the formula is showing "FALSE". I want cell C8 to contain the calculated number. What am I doing wrong?
Thanks.
Feb 27 2022 08:21 AM
@WMegl In C8 enter:
=IF(A8< 5000.01,A8*0.05,"something else")
.... where you can replace "something else" with whatever you want to display if A8 is NOT less then 5000.01.
Feb 27 2022 08:38 AM
Feb 27 2022 08:41 AM
Feb 27 2022 08:42 AM
@WMegl Why not upload a screenshot of your worksheet showing the formula "at work".
Feb 27 2022 11:40 AM
Feb 27 2022 12:14 PM
See the attached sample workbook.