Forum Discussion

Copper Contributor

Jun 04, 2024

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

Formulas and Functions

SergeiBaklan
Jun 06, 2024
Wade_Grimm

Please check it in attached file

Adding additional condition to Cell Formula.xlsx11 KB

MVP

Jun 04, 2024

As variant

=IF(J2="Payment", E2, IF( I2="Discover", -E2, E2) )

Wade_Grimm
Copper Contributor
Jun 05, 2024
SergeiBaklan
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.
- HansVogelaar
  MVP
  Jun 06, 2024
  Wade_Grimm
  
  SergeiBaklan's formula should work. but here is an alternative:
  
  IF((I2="Discover")*(J2<>"Payment"), -E2, E2)
- SergeiBaklan
  MVP
  Jun 06, 2024
  Wade_Grimm
  
  Please check it in attached file
  
  Adding additional condition to Cell Formula.xlsx11 KB
- Wade_Grimm
  Copper Contributor
  Jun 08, 2024
  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.23

Share

Resources