View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Daryl S Daryl S is offline
external usenet poster
 
Posts: 135
Default Is there a better way to write formula

Donna -

Try this:

=(18.89*(1+J23+N23)*(1+R23))*(Z23+107.56%)

Now if you need to change the numbers, you only need to change them once.

--
Daryl S


"Donna" wrote:

Is there a better way to write this formula? I have to write everything into
1 cell to produce a value.

=SUM(18.89+((J23+N23)*18.89)+(R23*(18.89+((J23+N23 )*18.89))))*SUM(Z23+107.56%)


The numeric values have to be manually inserted into each cell, can't have
hyperlinks.