Mutipl If and Stemanets

[kashifshahzad]

Dear All,
I have a sheet in which basically three columns , Available License Type, Required License Type, Status.

If Available License Type = “Light” and Required License Type = “Light” Then in the Status column result should be “Match”
If Available License Type = “Light” and Required License Type = “Heavy” Then in the Status column result should be “Need Upgrade”
If Available License Type = “Light” and Required License Type = “Construction” Then in the Status column result should be “Need Upgrade”

I have applied following formula but it gives me error #value.
=IF(AND(D3="Light",E3="Light"),"Match"),IF(AND(D3="Light",E3="Heavy"),"Need Upgrade"),IF(AND(D3="Light",E3="Construction"),"Need Upgrade")
Could you please help me how do I get the required result.
I have uploaded my sheet on following external link, as I didn’t find attached on this website.
https://www.dropbox.com/s/orsjcibfhwd5ftw/If.xlsx?dl=0

 

[SQUIDD]

hi

try this

=IF(AND(D3="Light",E3="Light"),"Match",IF(AND(D3="Light",E3="Heavy"),"Need Upgrade",IF(AND(D3="Light",E3="Construction"),"Need Upgrade","")))

you was closing off your bracket to early, your next nested if needed to go into the value if false part.

dave

 

[AliGW]

Cross-posted here; https://www.excelforum.com/excel-general/1178239-if-and.html#post4608958

 

[SQUIDD]

cross posted and no feedback.

I love these kind of people who are so impatient, they have to post on multiple forums and waste peoples time.
When they are satisfied with what they needed, no feedback.

Time could have been put to better use.

oh well, rant over

Dave

 

[AliGW]

Quite a lot of them around today, I'm afraid.

 

[SQUIDD]

well, at least people like you are activly spotting them

good catch

Dave

 

[snjpverma]

KASHIF, You can also try this shorter version.
=IF(D3="Light",IF(E3="Light","Match",IF(OR(E3={"Heavy","Construction"}),"Need Upgrade","")),"")

 

[Joe4]

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule #13 here along with the explanation: Forum Rules). This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

To fully comprehend what the issue with Cross-Posting is, please read this: [/COLOR]http://www.excelguru.ca/content.php?184

 

[kashifshahzad]

Thanks Everybody My problem is solved.