MS Excel question

[aolsuxs]

Is it possible to use the IF fucntion on text? I am trying to to have one spread sheet read another spreadsheet cell value and replace it if certain conditions are met.


For example, if the value is M then it writes Male in the cell otherwise it writes Female.

 

[Slowlearner]

Tried it out, seems to work, use the following format =IF(Cell=value, "Male", "Female"). You may have to refime the rules a bit.

 

[aolsuxs]

Does it matter if the cell is in another worksheet?

I am getting an #name? error on this part of the formula

'Worksheet1'!B6=M

 

[mayest]

You need to put text strings in quotes.

'Worksheet1'!B6="M" should work perfectly.