A cell (I'll call it A2S - "S" for the 2nd worksheet in workbook) programmed
with an FV function worked correctly when all cell references for that
function were on the same worksheet "S". Now references to cells used in the
calculation of A2S are from another worksheet "F" (i.e. A6F - "F" for first
worksheet in workbook) but I am getting the wrong value in cell A2S.

I thought I had this working perfectly before, with the references between
the two worksheets, but I have looked at everything I can and can see no
problems in the formula.

Also, I am having a problem using the value of cell A2S in an IF function on
the first page of the workbook. For instance, I want to refer to cell A2S
(and others like it - after we have corrected the above problem) in an
IF(A1F=X,A2S,IF(A1F=Y,B2S)), etc. on the first sheet of the workbook.

Am I unable to use the FV function or IF operator between worksheets? Is
that my problem?

Any help is appreciated.