Excel IF function problem

DT1640759
DT1640759 used Ask the Experts™
on
Hi,

I have a Excel formula problem, my Excel formula knowledge is not good. Please refer to my attached JPG file.

Thomas

What is my error on cell F2? I want to get a result (IF cell A2 = "AA" , E12 will X L1. IF cell A2 = "BB" , E12 will X L2. IF cell A2 = "CC" , E12 will X L3.)

Regards,
Thomas
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Excel & VBA Expert
Most Valuable Expert 2018
Awarded 2015
Commented:
What Excel version you are using? IFS formula is available in Excel 2016 and 365.

You may try another formula like below to get the desired output.

=E2*VLOOKUP(A2,$K$1:$L$3,2,0)

Open in new window

and then copy it down.
DT1640759System Engineer - IT

Author

Commented:
Hi Subodh,

My Excel version is 2016. Thanks for your help. Your formula work for me. I will close this case.

Regards,
Thomas
Subodh Tiwari (Neeraj)Excel & VBA Expert
Most Valuable Expert 2018
Awarded 2015
Commented:
You're welcome Thomas!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial