Forum Discussion
J B
Oct 28, 2017Copper Contributor
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 o...
- Oct 28, 2017
Practically the same
=((D9="INSN")+(D9="IADJ"))*0.5+(D9="PTEL")+(D9="BBVB")
SergeiBaklan
Oct 28, 2017Diamond Contributor
Practically the same
=((D9="INSN")+(D9="IADJ"))*0.5+(D9="PTEL")+(D9="BBVB")
J B
Oct 28, 2017Copper Contributor
AWESOME!!! Thank you for the quick and correct reply! =)