Oct 19 2020 01:59 AM
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 :(
Oct 19 2020 02:26 AM
Solution
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.
Oct 19 2020 11:56 PM
@NikolinoDE
Great thanks Nikolino. This solved my case :)
Really appriciate your help.
Oct 20 2020 04:13 AM
Oct 19 2020 02:26 AM
Solution
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.