using IF

[js]

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!!!

 

[js]

nvm... I figured it out... it should have looked a little more like this:
=IF(B1<(A1*1.65), "UPDATE", "")

Thanks all!



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!!!

 

[Guest]

Tools>options>calculations and set it to automatic

2. If that is set already try to replace = with = to force a calculation,
make sure no cells are formatted as text


Regards,

Peo Sjoblom