Nov 14 2021 05:49 PM
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
Nov 14 2021 10:48 PM
=IF(N2="S",E2,IF(N2="M",F2,IF(N2="L",G2)))