Multi-field/row formula help

Question

Hi everyone,

I'm trying to transform this original table:

Weight Rate 1Rate 2110121.51519.522027

and transform it into smaller fraction:

WeightRate 1Rate 2110121.11113.51.212151.31316.51.414181.51519.51.61621

Is it something that I can achieve by using Multi Field/Row formula?

Thanks!!

yovindapricila · Answer

The increment per 0.5kg is not proportional to the rates. Here's an example:

WeightRate 1Rate 2Rate 31.07.3910.747.651.57.9511.078.262.08.2711.838.69

so rate1 at 1.1kg would be 7.39 + [(7.95 - 7.38) / 5] = 7.39 + 0.114 = 7.50

rate1 at 1.2kg= 7.50 + 0.114 = 7.614

rate1 at 1.3kg= 7.61 + 0.114 = 7.724 and so on.

echuong1 · Answer

Is the logic for all 45 different for each one? Are you able to elaborate more on what these are? Can you post a sample?

yovindapricila · Answer

Hi Echuong. Thank you for your reply.

I have 45 rates column that I need to fill out. Is there any simpler solution rather than using 45 multi row formula tools?