Forum Discussion

J B's avatar
J B
Copper Contributor
Oct 28, 2017
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 o...
Formulas & Functions
Need Help
  • SergeiBaklan's avatar
    SergeiBaklan
    Oct 28, 2017

    Practically the same

    =((D9="INSN")+(D9="IADJ"))*0.5+(D9="PTEL")+(D9="BBVB")

     

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Oct 28, 2017

Few variants, for example

=SWITCH(D9,"INSN",0.5,"IADJ",0.5,"PTEL",1,"BBVB",1)

 

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Oct 28, 2017

    Practically the same

    =((D9="INSN")+(D9="IADJ"))*0.5+(D9="PTEL")+(D9="BBVB")

     

    • J B's avatar
      J B
      Copper Contributor
      Oct 28, 2017
      AWESOME!!! Thank you for the quick and correct reply! =)