SOLVED

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)
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)