Need help with IF formula

[Deepak]

Value in Cell should give result in B1
A1 - Yes, Then it should show B1 - 10
A1 - No, Then it should show B1 - 5
A1 - N/a, Then it should show B1 - 0

Thanks in advance

Don

 

[JE McGimpsey]

One way:

B1: =IF(A1="Yes",10,IF(A1="No",5,IF(A1="N/a",0,"Invalid value in A1")))

 

[iliace]

=VLOOKUP(LOWER(A1),{"yes",10; "no",5; "n/a",0},2,FALSE)