litestream
Active Member
- Joined
- Jul 24, 2006
- Messages
- 323
Can I have more than one "IF" statement in a formula?
For example:
If x=1 is true, then y, if not z
If x=2 is true, then v, if not w
If x=3 is true, then t, if not u
How would I put this in a formula?
Would it be better to use some VBA coding rather than a long formula?
For example:
If x=1 is true, then y, if not z
If x=2 is true, then v, if not w
If x=3 is true, then t, if not u
How would I put this in a formula?
Would it be better to use some VBA coding rather than a long formula?