IFS gone now what?

roc_ent

Board Regular
Joined
Jan 27, 2003
Messages
233
Office Version
2019
Platform
Windows
Hi all,

So I'm trying to figure out what I need since it seems that the IFS formula has been taken away.

I have several questions that students need to answer, and their choice from a drop down list is in cells
H3 and the list is Agree, Disagree, Not Applicable. The results will be tabulated in cell AX where agree will be 10, disagree would be 5, n/a 0.

Can anyone help me out on this. It seems so basic but just can't figure it out. Thanks in advance.
 

Trebor76

Well-known Member
Joined
Jul 23, 2007
Messages
4,467
Hi roc_ent,

Dose this do what you're after:

=VLOOKUP(H3,{"Agree",10;"Disagree",5;"Not Applicable",0},2,FALSE)

Regards,

Robert
 

roc_ent

Board Regular
Joined
Jan 27, 2003
Messages
233
Office Version
2019
Platform
Windows
Hi roc_ent,

Dose this do what you're after:

=VLOOKUP(H3,{"Agree",10;"Disagree",5;"Not Applicable",0},2,FALSE)

Regards,

Robert
Perfect, thank you so much .........
 

Forum statistics

Threads
1,082,504
Messages
5,365,956
Members
400,863
Latest member
kimtid

Some videos you may like

This Week's Hot Topics

Top