answersLogoWhite

0


Want this question answered?

Be notified when an answer is posted

Add your answer:

Earn +20 pts
Q: What formula would you use to enter a file name into a cell?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

Can you put Excel files in a cell?

No, but you can put a link to a file in a cell. Enter the text you want to add as the link and then press Ctrl - K and then you will be able to specify a file to link to.


How can a change of data entered in a cell in excel affect the other cell on a different sheet?

You can have formulas on a sheet that refer to another sheet or even another file. For example on Sheet3 you could have the following formula which adds values in cells on Sheet1 and Sheet2. =Sheet1!A3 + Sheet2!C5 That would add those two values and have the result in whatever cell you put that formula. If the values in either of those two cells are changed, then the formula will automatically update the result.


Can I file your cell phone bill on bankruptcy?

No, you cannot file my cell phone bill in a bankruptcy. However, you can file YOUR cell phone bill in a bankruptcy.


How are Biological Viruses and Computer viruses alike?

Computer viruses can infect a file much like a Biological virus can infect a cell, they then spread from file to file or cell to cell.


How do you check excel sheet tables in two files?

If you just want to visually check them, you can open both of them and arrange them in a tiled format from the Window menu, by picking Arrange. You will be able to see both files on the screen.If you want to do calculations across them, then you can refer to another workbook by having its name enclosed in square brackets, followed by the particular sheet name, all enclosed in single quotes and then having an exclamation mark and the cell reference in a formula on the first workbook. So if you wanted to refer to cell A3 on Sheet1 in a file called FirstFile.xls then you would put this in another file:='[FirstFile.xls]Sheet1'!A3You may also have to even include the full path to the file, so it could be like this:='C:\My Documents\[FirstFile.xls]Sheet1'!A3If you were doing a formula, say to add a value in cell C7 on the open file to the other, then the formula would be:='C:\My Documents\[FirstFile.xls]Sheet1'!A3+C7


How can someone file a police report on a stolen cell phone?

To file a police report on a stolen cell phone, you should contact your local police department either by phone or by visiting their station. Provide details such as when and where the theft occurred, your phone's make and model, and any identifying features or information you have. They will guide you through the necessary steps to complete the report.


How do you enter to a file in unix?

Not sure what you mean by enter a file; you could use an editor, such as vi, emacs, nano, pine, etc. to edit it.


How do you get a video onto a DVD from an HTC cell phone?

You would start by transferring the video file to a computer. Then you would need to download DVD conversion software to put the video file into the DVD format. After the file is in DVD format you would need to burn the file to a DVD using a DVD burning software.


What file do you enter in the Grand Theft Auto 4 setup?

You go on any file.


How do you extract file and folders name in Excel?

If you mean for the current file, you could use the CELL function and its filename option like this: =CELL("filename",A2) This will give you the name and folders for the file. It can also be used to get the details by referencing a cell in another file. =CELL("filename",'C:\[ABc.xls]Sheet1'!$A$5)


You enter a value in one excel file how can it automatically enter in another excel file?

You have to set up a link between the two files. Open both files. Copy the cell or cells from one spreadsheet that you want to be the same in the other file and then go to the other file, and to the place in it that you want to have the values. Then instead of doing an ordinary paste, do a Paste Link, which will be on the Edit menu. Save both files. Then any time you put something into the original files cells, they will change in the other file too.


How do you get pictures in Wikipedia?

Enter the Wikimedia file code.