Help in formula

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)

@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.



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.

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

Your welcome

Thank you that I will be allowed to help.

I know I don't know anything (Socrates)