Forum Discussion
Deano921
Feb 12, 2024Copper Contributor
Using or in an if Statement.
I am trying to understand the "Or" concept in Excel formulas. I have 2 fields in a excel file I am using. A field called "Type" and an amount field. The two conditions is the "Type" that I want ...
OliverScheurich
Feb 12, 2024Gold Contributor
=IF(OR(C13="Payment",C13="Check"),-H13,H13)
=IF(OR(C13="Payment",C13="Check"),H13*-1,H13)
Do these formulas return the intended result?