Forum Discussion

Andre0420's avatar
Andre0420
Copper Contributor
Sep 28, 2023
Solved

If, and, else formula

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(...
  • HansVogelaar's avatar
    Sep 28, 2023

    Andre0420 

    In G333:

     

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

Resources