View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Marathon Marathon is offline
external usenet poster
 
Posts: 5
Default If Statement Checking Formula NOT Value in a Cell

Hi,

Is it possible to write an "IF" statement which checks not the value of the
cell, but whether the formula in cell gets data from a certain "Sheet".

Let say, in "A1" cell of the "Sheet4" I have this formula
"=Sheet1!A1+Sheet2!A1+Sheet3!A1". I would like to check whether the formula
in cell "A1" of "Sheet4" uses data from "Sheet2". Is this possible?

Thanks.