View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ken Johnson Ken Johnson is offline
external usenet poster
 
Posts: 1,073
Default What is wrong in formula.


Maybe the option the Find is using is "Look in: Formulas", so it has
gone to a cell with the formula containing 50 (eg =IF(E500,B49+1,""),
while the result of the formula is 47.

If this is the case then change to "Look in: Values"

Ken Johnson