Forum Discussion
if function for text and value
can you help me please to formulate this function i want to use if function and at the end result want to sum the values
like
if the word "yes" in there in the cell b2 then write the value "1" and if the word "No" is there in the cell b2 then write the value "0" and if the word "do not know" is there in the cell b2 then write "0"
i want this function to be repeated for cell B2,B3,B4
and at the end i want to sum the value of B2+b3+b4
thank you in advance.
4 Replies
SergeiBaklan thank you a lot it is really helpful
but what if the value for Yes I wanted to be +2, No -1
which formula i can use?
