Thread: formula
View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.misc
chedd via OfficeKB.com
 
Posts: n/a
Default formula

chedd wrote:
Hi

[quoted text clipped - 5 lines]
reply. I have tried the formula below, but I still having 100% showing in
cell D. Has any one have any further ideas?


Sorry i took the formula from B10 instead B11 (=B11-'Apr 06 monthly report'!
B11)



Where it is registered 0 in cell B i am getting 0% in cell D, but when the
cells B and C register above 0 each i.e 1 and 1 i am getting 100% with cell
E reading high instead of Equal.

--
Message posted via http://www.officekb.com