I need to use IF function with 3 conditions:
1) to multiply the number by the serial row with the last number of the date column.
2) to continue the process, with next batch of numbers, with similar criteria
3) to ignore the second last serial column (serial), before the date column
data (left to right)
Solved by I. J. in 18 mins