Excel formula

  • Thread starter Thread starter George A.Yorks
  • Start date Start date
G

George A.Yorks

tried to use a formula created for me by "Random" and the
following appears in the cell #NAME? What does it mean and
why does it appear?
 
Looks like Random had a type and omitted a ! in one of the sheetname
references.

This should work.

=IF(Sheet1!B4=Sheet1!B1,2,If(Sheet1!B4>Sheet1!B1,1,If(Sheet1!B4<Sheet1!B1,4)
))

PC
 
The formula probably makes reference to a named range or
cell that does not exist in your spreadsheet. Since
someone else wrote the formula in another spreadsheet
with the ranges named, this seems likely to be the
problem. Make sure the name exists. On the Insert menu,
point to Name, and then click Define. If the name is not
listed, add the name by using the Define command.
 
Back
Top