Question about Excel (SS8SATAS5128400R)
You can import data from one sheet to another. If you want to bring a total from Sheet 1 to Sheet 2, then in Sheet 2 enter [=sheetname!cell] (without the brackets of course. You will now have the data from Sheet 1 in a cell in Sheet 2 and you can do anything you want with it. One note: if the sheet name has a space in it (Sheet Name) you have to enclose the name in single quotes; that tells it that the whole thing is the name. For example, Monthly Sales, A10 is the total for last month; to put it in this month for a running total, you would enter in Sheet 2 ['Monthly Sales'!A10] (without the brackets again). Now you can have a running total between the two sheets.
Posted on Dec 31, 2008
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
Posted on Jan 02, 2017
Tips for a great answer:
Mar 03, 2011 | Excel (SS8SATAS5128400R)
IF condition is “=IF(C6>6000,0.15%*(C6-6000),0)”
C6>6000 is your logical condition
0.15%*(C6-6000) would be the value if your logical condition
is TRUE, and
0 would be the value if your logical condition is FALSE.
IF condition is “(IF(C6>30000,0.3%*(C6-30000)))”
C6>30000 is your logical condition
0.3%*(C6-30000) would be the value if your logical condition
is TRUE, and
? would be the value if your logical condition is FALSE.
You are missing the value if it is FALSE.
be of some help/idea. Post back how things turns up or should you need
Good luck and kind regards.
Oct 26, 2007 | Excel (SS8SATAS5128400R)
Jun 16, 2008 | Excel (SS8SATAS5128400R)
Jun 13, 2008 | Excel (SS8SATAS5128400R)
May 22, 2008 | Excel (SS8SATAS5128400R)
Feb 16, 2008 | Excel (SS8SATAS5128400R)
137 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: