0

So I am looking to write a function code that will assign different values to different answers. I.E if someone responds with a "strongly agree" I need a 4 value assigned but if they responded "agree somewhat" I need a 3 assigned.

I imagine this uses a combo of IF, OR and AND functions but I am unsure

Chayse Leith
  • 1

1 Answers1

2

Create a lookup table (on right in photo) to store your mappings. Then use a VLOOKUP to convert your string input to a score output. See photo below with setup & usecase

enter image description here

urdearboy
  • 14,439
  • 5
  • 28
  • 58