Forum Discussion

Yrrah55555's avatar
Yrrah55555
Copper Contributor
Sep 08, 2023

enter two formula's in one cel

Case:
cel 1 contains a simple som formula ( for example outcome "$20" )
cel 2 contains a IF formula either displaying "YES" or "NO"

If the result for cel 2 is "YES" I need cel 1 to change from $20 into "0" (or "zero")

I know you can combine two formula's in one cel with "&" but I seem not be abloe to het the IF formala right in this combined cel.

Thanks a million for any help.
Harry

Formulas and Functions

1 Reply

  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Sep 08, 2023

    Yrrah55555 

    Cell 1 now has a formula:

     

    =some_formula

     

    Change it to

     

    =IF(cell_2="YES", 0, some_formula)

     

    substituting the correct cell address and formula.

Resources