modify formula same cell multiple times

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Neeraj Sir,

In his previous post, I asked him there must be some logic for multiplication, if we have to count number of times, which will not help getting shorter formula.

Ian,

Please explain logic behind it

You have inconsistent formulas in column B so before copying the suggested formula down the rows, remember to change the formula where formula changes by following the method used in the suggested formula.
e.g. the formula changes in B13 so change your formula here instead of copying the formula from B12 down the cells.

In B13

=G13^6*J13^3*M13^5*S13^3

Same way adjust all your formulas in column B.

@Shums
Maybe you are right though I don't see any pattern. :)

ASKER

The logic behind it is to weight the multiplier to suit the model.
In the attached sheet there are two models ...... rows 5:12 and 13:24
taking cells B5:B12 as an example col 'P' is most significant followed
by column 'D'

ASKER

Neeraj,
My keyboard doesn't have the power symbol. Normally it's the left key on the top row.
Can you tell me the shortcut method to insert it ?
Thanks
Ian

It is Shift+6.

Or you can use Alt+94.

And your min 99.99 still be with this formula?

ASKER

Hi Shums,
Yes the 99 min worked perfectly but since found that the idea was not so good after all :)

Please check your formula for B24. Doesn't seems to calculate as per your model 1200
B24 where model is 1200 in Column A:

=D24*D24*D24*G24*G24*N24*N24*N24*N24*N24*S24

B23 where model is 1200 in Column A:

=G23*G23*G23*G23*G23*G23*J23*J23*J23*M23*M23*M23*M23*M23*S23*S23*S23*S23

Is there any other logic?

ASKER

Yes that works Neeraj. The power above 6 looked a little different
cheers
Ian

Anyway, you can use below formula for changing patterns.

=IF(A21=800,D21^4*G21^2*J21^3*P21^6,G21^6*J21^3*M21^5*S21^4)

You're welcome Ian! Glad it worked.