If, and, else formula

Copper Contributor

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

1 Reply

@Andre0420 

In G333:

 

=D333*IF(AND(C333="Alkaline", F333="Sold"), 50, 20)