Forum Discussion
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
1 Reply
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.
