MS Excel question

aolsuxs

Senior member
Dec 6, 2000
687
0
0
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

Senior member
Mar 20, 2000
873
0
0
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

Senior member
Dec 6, 2000
687
0
0
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

Senior member
Jun 30, 2006
306
0
0
You need to put text strings in quotes.

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