 # =IF Statements

I am a basic Excel user and need assistance with using an IF statement.

Essentially I am trying to build a quote sheet where the user enters either a S,M or L for the size in cell N2, which then returns a corresponding value in M2 (Price) that matches the selection (N2) with the matching value in E2-G2 (small,medium,large). I can do this for one size (see M2) but I cannot make it work with the multiple sizes (M3) if I try to use the If and OR functions which I tried in many combinations (see below).

Not sure if I should be using the IF statement with OR, or if I should be using the IF statement with AND.

Basically; If N2=S then M2=E2, if N2=M then M2=F2, and if N2=L then M2=G2

I tried the following with no success.

=IF(OR(N3="S",N3="M",N3="L"),M3=E3*1,M3=F3*1,M3=G3*1))

Thank you in advance for any assistance.

Cheers,

Dennis

2 Replies

# Re: =IF Statements

``=INDEX(E2:G2,MATCH(N2,\$B\$1:\$D\$1,0))``

# Re: =IF Statements

=IF(N2="S",E2,IF(N2="M",F2,IF(N2="L",G2)))