Is there a better way to write formula

  • Thread starter Thread starter Donna
  • Start date Start date
D

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

Look at this:

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

Regards,
Per
 
Back
Top