Borland dBase III Plus
asked on
Excel IF function problem
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
My Excel version is 2016. Thanks for your help. Your formula work for me. I will close this case.
Regards,
Thomas