In Excel '97, I am trying to get notified on only the necessary items in
1,000+ total items.
I'm using it with column "A" as material cost and "B" as current sell price.
The goal is to be informed which ones are less than the goal of cost +65%.
It actually worked with this formula in "C":
=IF(B1<A1*1.65, "UPDATE", "")
*BUT*
after filling in the whole column "C" with that formula, the column doesn't
show anything, even if the result SHOULD be showing "UPDATE" until AFTER
clicking the equals sign for each individual cell, which defeats the purpose
of limiting the amount of time and effort spent on unnecessary items.

Please HELP??
Thanks!!!
--
Jason