"if" cannot refer to other sheet in same workbook ?!

[SVEN AERTS]

=IF(100>E6>0;"=ARCHI!D8";0)

returns an error.

Strange !

In my cell of this worksheet, I want:
If cell E6 is between 100 and 0
then one should expect to see the value as per sheet ARCHI, D8
if not it should put a 0

But it doesn't.... apparently refering to other sheets of the same workbook
isn't allowed ?

 

[Bernard REY]

SVEN AERTS wrote :

=IF(100>E6>0;"=ARCHI!D8";0)

returns an error.

Strange !

Not that much, in fact. There are two reasons for not obtaining the expected
results.

"100>E6>0" can't be evaluated, you have to make it in two parts:
"AND(100>E6;E6>0)" would do it, or "(100>E6)*(E6>0)"

Entering "=ARCHI!D8" will simply display it as text in the cell.
To have it display the actual content of the ACHI!D8 cell, don't
write it with quotes.

This should give the expected result:

=IF(AND(100>E6;E6>0);ARCHI!D8;0)