Sep 28 2023 06:11 AM
Hello, I am trying to make a calculation that will show me the value of the conditions are met:
C333 = Alkaline
F333 = Sold
cell G333 should be Cell D*50, else, D333*20
=IF(AND(C333="Alkaline",F333="Sold"), (G333=D333*50), (G333=D333*20))
this gives me a result of False instead of the value. please help.
thank you
Sep 28 2023 06:17 AM