Forum Discussion
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 ...
=IF(OR(C13="Payment",C13="Check"),-H13,H13)
=IF(OR(C13="Payment",C13="Check"),H13*-1,H13)
Do these formulas return the intended result?
Yes, the second one is Perfect! Thank you very much. I am now able to do a conditional "OR" in both Excel and Access!
- I really didn't know if I would get an answer or not. I have never used this technique to solve a formula problem before, Again, thank you very much for giving me the solution!