Forum Discussion
Adding additional condition to Cell Formula
I am using the following to convert a value to a negative number from cell (E2) into a new cell (D2) when cell (I2) equals "Discover" and it works fine. But I want to add an exception to not convert to negative into (D2) if another cell (J2) value has(equals) "Payment". If it does equal "Payment" just Set (D2) to (E2).
For a cell D2 I am using the following with success:
=IF(I2="Discover",(E2*(0-1)),E2)
Now I want to add another condition(or exception) to the above: Even if I2 is "Discover" but cell J2 has "Payment" then just set D2 to E2 (even when (I2) is "Discover"
Appreciate any tips, Thank You
Thank you Sergei, i tried this as a cell logical formula but it errored out saying to many arguments. I messed around with parentheses a bit trying to make a single statement but no luck.
SergeiBaklan's formula should work. but here is an alternative:
IF((I2="Discover")*(J2<>"Payment"), -E2, E2)
