Current location - Training Enrollment Network - Mathematics courses - Segmentation calculation in EXCEL
Segmentation calculation in EXCEL
1. How to compile the formula for finding y value in another table in EXCEL?

=INDIRECT ("calculation table! B "& (int ($ x $110)+1), true)+($ x $ 1-indirect ("calculation table! A "&(int ($ x $110)+1), true)) * indirect ("calculation table! C " & amp(INT($ X $ 1/ 10)+ 1),TRUE)

$X$ 1 corresponds to x, which can be replaced by other cell addresses.

2. Assuming that the value of y is known now, how to compile the formula for finding the value of x in another table in EXCEL?

This may have multiple values and is not unique, so it cannot be used as a formula.