Converting text to numerals across spreadsheets

[Guest]

I'm referencing cells on a different worksheet with information in, but where
it is says 'Yes' on Sheet 1 I need it to say '1' on sheet 2. Likewise, where
it says 'No' on sheet 1, I need it to say '2' on sheet 2. Can anyone tell me
how this could be achieved?

Thanks.

 

[JulieD]

Hi Ed

use an IF statement
=IF(Sheet1!A1="yes",1,IF(Sheet1!A1="no",2,""))

Cheers
JulieD

 

[Frank Kabel]

Hi
do you mean
=IF('sheet1'!A1="Yes",1,IF('sheet1'!A1="No",2,"something else"))

 

[Guest]

if only a yes or no value is enter into the referencing cells, this formula
will work
=IF(Sheet1!A1="YES",1,2)