Display value of text from one worksheet into another as number

[yogiyosh]

I,m a novice with Excel, I'm trying to convert any text enterd into a cell from one worksheet, then let the other worksheet dislplay that text as a true or false value (1 or 0) I've tried using the IF statement, but am not getting very far!! Can anybody help????

 

[SQLBI]

Hi,

Your IF statment syntax should be as follows...

=IF(logicalTest, IfTrue, IfFalse)

If you need a little more, can you please post a more detailed question, giveing examples of what you are trying to test and the structure of your spreadsheet. EG. Is Sheet1 CellA1 always going to be CellA1 in Sheet2?



Leigh Moore
Solutions 4 MS Office Ltd

http://www.solutions4msoffice.co.uk

 

[yogiyosh]

Ok, apologies. Sheet 1 is entry sheet, The user types in a location into a row of cells, say A1:A10. On the next work sheet(Sheet 2) a table picks up the text entered as a value of 1 or 0 (true or false). chart 1 then calculates these rows to produce my final graph. I hope this makes it clearer???

 

[dk99]

YOu can try the following:-

=IF(Sheet1!A1>0,1,0)

and so on for each cell that is on sheet one.

Basically if sheet 1 cell A1 is greater than 0 (ie. something in it) it will produce a 1 else it will produce a 0.

Hope it helps.

 

[yogiyosh]

Thanks for the tip, but now I've tried that a requester box opens "Update values: Entry Sheet (From addins)" additionally the cell reports a #VALUE! error. I'm obiously doing something wrong!!