Converting text to numerals across spreadsheets

E

Ed Anton

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.
 
J

JulieD

Hi Ed

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

Cheers
JulieD
 
F

Frank Kabel

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

RayG

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