Is there a better way to write formula

[Donna]

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.

 

[Daryl S]

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.

 

[Luke M]

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%)

 

[Bernard Liengme]

Now nee to use SUM operator
=(18.89+((J23+N23)*18.89)+(R23*(18.89+((J23+N23)*18.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

 

[Donna]

Thanks, that works great.

 

[Per Jessen]

Hi

Look at this:

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

Regards,
Per