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...
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.
Got it working using the following:
=IF(AND(D67="Discover",E67="PAYMENT"),0,G67*(0-1))
And I added another value of zero. Thanks for your help. Set me on the right trail. Bought a book - haha See sample data output below.New
Source(D67) For(E67) AmountF(67) Amount(G67)
Discover Restaurant -160.94 160.94
Discover Payment 0.00 -1,500.00
Discover Payment 0.00 -1,615.73
Discover Payment 0.00 -1,500.00
Discover Payment 0.00 -1,592.07
Discover Payment 0.00 -1,500.00
Discover Restaurant -71.10 - 71.10
Discover Restaurant -107.17 107.17
Discover Payment 0.00 -500.00
Discover Payment 0.00 -1,000.00
Discover Payment 0.00 -1,000.00
Discover Restaurant -37.46 37.46
Discover Restaurant -15.23 15.23SergeiBaklan's formula should work. but here is an alternative:
IF((I2="Discover")*(J2<>"Payment"), -E2, E2)
