I am using a command that works on one sheet in excel but seems to ignore text in another sheet:
=IF(A1="yes",B1& " is my favorite food.","I don’t have a favorite food.") is being used to generate a statement and works in sheet2.
<tbody>
</tbody>
But when I use the same code on sheet 1 of my spread sheet it doesnt work after line 1 even if it says the same value in columns A="Yes" B="Pork"? As far as I can tell the formatting of cells is all the same "general" format but for every line: whether I say Yes or no it just says "I don't have a favorite food"
<tbody>
</tbody>
Any ideas how I might adapt the formula to correct this error?
=IF(A1="yes",B1& " is my favorite food.","I don’t have a favorite food.") is being used to generate a statement and works in sheet2.
A | B | C | |
1 | Yes | Pork | Pork is my favorite food |
2 | No | I don't have a favorite food |
<tbody>
</tbody>
But when I use the same code on sheet 1 of my spread sheet it doesnt work after line 1 even if it says the same value in columns A="Yes" B="Pork"? As far as I can tell the formatting of cells is all the same "general" format but for every line: whether I say Yes or no it just says "I don't have a favorite food"
A | B | C | |
1 | Yes | Pork | Pork is my favorite food |
2 | Yes | Pork | I don't have a favorite food |
<tbody>
</tbody>
Any ideas how I might adapt the formula to correct this error?