bJohn,

What am I missing here? How does automatic calculation resolve his question
about his IF function?

Thanks,
Barb

"John" wrote:

check toolsoptionscalculation tab and automatic is selected
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)


" wrote:


is there a way to avoid repeating yourself in an excel if formula?

for example:

=IF(ROUND(+E4/4,-3)10000,ROUND(+E4/4,-3),0)

when excel evaluates the expression as true, you need to type in and
evaluate the formula again.

is there a better way?

-greg