is there a way to avoid repeating yourself in an excel if formula?
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
|