SOLVED

Help in formula

%3CLINGO-SUB%20id%3D%22lingo-sub-1794751%22%20slang%3D%22en-US%22%3EHelp%20in%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1794751%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20sheet%20where%20in%20E1%20data%20is%20%221%20-%20Volunteer%22%20and%20in%20F1%20the%20user%20has%20to%20choose%20Yes%20or%20No.%3CBR%20%2F%3ESo%20I%20need%20a%20formula%20When%20the%20E1%3D1%20-%20Volunteer%20and%20F1%3DYes%20the%20outcome%20should%20give%200%2C5%20points%2C%20false%20is%200%20points%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHave%20tried%20different%20IF's%20AND's%20and%20whatever%2C%20but%20cannot%20get%20it%20right%20%3CLI-EMOJI%20id%3D%22lia_disappointed-face%22%20title%3D%22%3Adisappointed_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1794751%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1794836%22%20slang%3D%22de-DE%22%3ESubject%3A%20Help%20in%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1794836%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F120847%22%20target%3D%22_blank%22%3E%40Ari%20Suominen%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThere%20are%20many%20ways%20in%20Excel%20that%20lead%20to%20a%20result%2C%20here%20is%20one%20of%20them.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20be%20happy%20to%20know%20if%20I%20could%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E*%20Kindly%20Mark%20and%20Vote%20this%20reply%20if%20it%20helps%20please%2C%20as%20it%20will%20be%20beneficial%20to%20more%20community%20members%20reading%20here.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

I have a sheet where in E1 data is "1 - Volunteer" and in F1 the user has to choose Yes or No.
So I need a formula When the E1=1 - Volunteer and F1=Yes the outcome should give 0,5 points, false is 0 points

 

Have tried different IF's AND's and whatever, but cannot get it right

3 Replies
best response confirmed by Ari Suominen (Occasional Contributor)
Solution

@Ari Suominen 

 

There are many ways in Excel that lead to a result, here is one of them.

 

I would be happy to know if I could help.

 

Nikolino

I know I don't know anything (Socrates)

 

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.

@Nikolino 
Great thanks Nikolino. This solved my case
Really appriciate your help.

Your welcome

Thank you that I will be allowed to help.


Cheers
Nikolino
I know I don't know anything (Socrates)