mark the excel novice
New Member
- Joined
- Jul 6, 2021
- Messages
- 8
- Office Version
- 365
- Platform
- Windows
Hi,
So my question is if a1 = x or y or z then take the value from c1, if a1 = a or b or c take the value from c2
I know I can do something similar to this way:
IFS( A1="x",C1, A1="a",C2)
However, as I add more and more options it becomes a long string
IFS( A1="x",C1, A1="y",C1,A1="z",C1,A1="a",C2,A1="b",C2,A1="c",C2)
I want to be able to say x,y or z = C1, a,b, or c = C2 and be able to just add d,e,f,g,h,i,j,k etc
Is that possible?
So my question is if a1 = x or y or z then take the value from c1, if a1 = a or b or c take the value from c2
I know I can do something similar to this way:
IFS( A1="x",C1, A1="a",C2)
However, as I add more and more options it becomes a long string
IFS( A1="x",C1, A1="y",C1,A1="z",C1,A1="a",C2,A1="b",C2,A1="c",C2)
I want to be able to say x,y or z = C1, a,b, or c = C2 and be able to just add d,e,f,g,h,i,j,k etc
Is that possible?