View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] gregory.halsey@gmail.com is offline
external usenet poster
 
Posts: 2
Default 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