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 $...
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.