Help!
I want C2 to say 'Male' if B2 has 'M' inputted, but I also want C2 to say 'Female' if B2 has 'F' inputted.
What would be the formula?
🙂
MacBook Air, OS X Yosemite (10.10.5)
put this formula in cellC2
=if(B2="M", "Male, IF(B2="F", "Female", ""))
Thank you! If I had certain words in the table, such as B1 said Yes, B2 said Yes, etc. how would i get B22 to say "Yes" if the majority of words in the table is "Yes"
Hi appleman,
I take it this is a different "B2" than the one mentioned above.
Here is a sample. Each column (B, C, D) is a separate example. Row 22 is a Footer row, so the first formula below has been used in each column (with "B" set to match the column containing the formula). You have not specified what is to happen if 'Yes' does not constitute a majority of the 'votes' recorded; I've used "alternate response" for this case.
If Row 22 is defined as a Footer row, and the table has no Header rows:
=IF(COUNTA(B)/COUNTIF(B,"Yes")<2,"Yes","alternate response")
If Row 22 is NOT a Footer row, the formula will need to specify the range of cells to be counted more specificly:
=IF(COUNTA(B1:B21)/COUNTIF(B1:B21,"Yes")<2,"Yes","alternate response")
COUNTA counts the number of cells in the range containing any text; COUNTIF counts only the cells containing text that matches the specified text (Yes).
Both functions ignore empty cells.
Regards,
Barry
Formula?
