Excel 2010 - use result from one sheet in a formula on another

[dsmith910]

Hi

I have a set of spreadsheets all of which have calculation fields on them.

I need to pose the following question on sheet 5

=IF(Sheet4!L11=1,"=",0)

Cell L11 on Sheet 4 is calculated from figures calculated on Sheet 3 which in turn are calculated from figures on Sheet 2.

At the moment I get a 0 (zero) result regardless of what is actually shown on Sheet4 Cell L11.

Am I asking two much to hope that I can use the results from sheet 4 to create a list in sheet 5?
.... or have I done something 'dumb' in the above formula?

I can't see what I've done wrong - anyone able to help?

 

[mintjulep]

regardless of what is actually shown on Sheet4 Cell L11.

Has Sheet4 Cell L11 been 1 yet?

 

[SkipVought]

hi,

Is the value in L11 a numeric 1 or a text 1? BIG DIFFERENCE!!!

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[lionelhill]

and also, is it the product of a floating-point calculation? Integer calculations are exact, so it's safe to test them exactly (L11=1). Floating point calculations often produce answers that are not quite exact (1.0000000000001) but look like 1 when displayed. It's sometimes safer to test abs(L11-1)<verysmallnumber