Thread: is there a way to avoid repeating yourself in an excel if formula?
View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
Dana DeLouis Dana DeLouis is offline
external usenet poster
  
Posts: 947
Default is there a way to avoid repeating yourself in an excel if form
Hi. I don't think it's used very much anymore, as it is usually written
like this now:

= --(A1=38000)*ROUND(A1/4,-3)

--
Dana DeLouis
Windows XP & Office 2007


"Art" wrote in message
...
Dana,

=GESTEP(A1,38000)*ROUND(A1/4,-3)

Nice! I never noticed GESTEP before -- thanks.



Reply With QuoteReply With Quote