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
You must be logged in to post a comment.