Transfering the numbers with some calculations inside
Closed
emelina100
Posts
1
Registration date
Saturday September 5, 2015
Status
Member
Last seen
September 5, 2015
-
Sep 5, 2015 at 10:41 AM
smuneeb Posts 67 Registration date Saturday September 5, 2015 Status Member Last seen March 8, 2017 - Sep 5, 2015 at 05:02 PM
smuneeb Posts 67 Registration date Saturday September 5, 2015 Status Member Last seen March 8, 2017 - Sep 5, 2015 at 05:02 PM
Related:
- Transfering the numbers with some calculations inside
- Spreadsheet calculations - Guide
- Where is the calculator on my android phone - Guide
- Electrical calculations software - Download - Calculators
- The standard transfer speed of your wireless connection is - Guide
- Transfering sound from laptop to TV with HDMI ✓ - Laptop Forum
1 response
smuneeb
Posts
67
Registration date
Saturday September 5, 2015
Status
Member
Last seen
March 8, 2017
1
Sep 5, 2015 at 05:02 PM
Sep 5, 2015 at 05:02 PM
Hi
If you want to reformulate some data to another sheet
then its work as given below
Suppose you have a data in Sheet1 at Column A and want to transfer data to another sheet named as Sheet2 in Column B with any formula,
you have to go to Sheet2 in Column B Cell
write "=Sheet1!A1" in Column B Cell No "B1"
it implies that it will fetch the data from Sheet1 and Column A Cell No "A1" to Sheet2 in Column B Cell No "B1"
if You want above example with any formula then
write =SUM(Sheet1!A1+A1) in Column B Cell No "B1"
it implies that it will sum the data from Sheet1 of Column A Cell No "A1" and Sheet2 of Column A Cell "A1" to Sheet2 in Column B Cell No "B1".
I hope you get the point
Thanks
If you want to reformulate some data to another sheet
then its work as given below
Suppose you have a data in Sheet1 at Column A and want to transfer data to another sheet named as Sheet2 in Column B with any formula,
you have to go to Sheet2 in Column B Cell
write "=Sheet1!A1" in Column B Cell No "B1"
it implies that it will fetch the data from Sheet1 and Column A Cell No "A1" to Sheet2 in Column B Cell No "B1"
if You want above example with any formula then
write =SUM(Sheet1!A1+A1) in Column B Cell No "B1"
it implies that it will sum the data from Sheet1 of Column A Cell No "A1" and Sheet2 of Column A Cell "A1" to Sheet2 in Column B Cell No "B1".
I hope you get the point
Thanks
