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.

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.

Your formula can be condensed to this:

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

which is also equal to:

=18.89*(1+J23*(1+R23)+N23*(1+R23)+R23)*(Z23+107.56 %)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"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.

Now nee to use SUM operator
=(18.89+((J23+N23)*18.89)+(R23*(18.89+((J23+N23)*1 8.89))))*(Z23+107.56%)
and then extract the 18.89 and remove unneeded brackets
=18.89*(1+J23+N23+(R23*(1+J23+N23)))*(Z23+107.56%)
You need to double check this
best wishes
--
Bernard Liengme
http://people.stfx.ca/bliengme
Microsoft Excel MVP

"Donna" wrote in message
...
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.

Thanks, that works great.

"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.

Hi

Look at this:

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

Regards,
Per

"Donna" skrev i meddelelsen
...
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.