Operation in the excel sheet I would like to quote another figure in a box, how …

Such as:= B19 * $ S $ 7 / ($ S $ 5 – $ S $ 5 * C8) in the C8 is another sheet, and the formula should be how to express?

= B19 * $ S $ 7 / ($ S $ 5 – $ S $ 5 * sheet2! C8) on it ..you actually enter the equation when you select with the mouse instead of manual input would not be such a problem ..will automatically help you fill in the appropriate form

Sure enough, the direct use of the mouse much easier, thank you heroes of ~

Sheet1! C8 = B19 * $ S $ 7 / ($ S $ 5 – $ S $ 5 * Sheet1! C8)

in the C8 preceded The name on another sheet table! For example:sheet2! C8

Suppose you name another worksheet called Sheet2, then the formula should be = B19 * $ S $ 7 / ($ S $ 5 – $ S $ 5 * Sheet2! C8)

Leave a Reply