Forum Discussion
Solved
Needing help with a cell's value (4 options) based another cells verbiage.
Would someone be able to assist me with a formula? I'm needing cells in column "A" to show a value based another cell's verbiage from within the same row. There are four different verbiages, but only 2 different values that I need processed. Example spreadsheet provided. Thank you in advance.
Practically the same
=((D9="INSN")+(D9="IADJ"))*0.5+(D9="PTEL")+(D9="BBVB")
3 Replies
Few variants, for example
=SWITCH(D9,"INSN",0.5,"IADJ",0.5,"PTEL",1,"BBVB",1)
Practically the same
=((D9="INSN")+(D9="IADJ"))*0.5+(D9="PTEL")+(D9="BBVB")
- AWESOME!!! Thank you for the quick and correct reply! =)
