I can't figure out this formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I inherited a spreadsheet. One of the cells has this formula:
{=TABLE(,B1)}. There's a value in the cell...like it's calculating something
but I can't figure out what it's referring to. Can someone explain this to
me?
 
Steve said:
I inherited a spreadsheet. One of the cells has this formula:
{=TABLE(,B1)}. There's a value in the cell...like it's calculating something
but I can't figure out what it's referring to. Can someone explain this to
me?
Click to expand...

Highlight the cell, click on Tools-Auditing-Trace Precedents and see what
it's referencing......
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auto Fill Format or Copying Formulas 1
Displaying zeros in cells 2
Help with figuring formula to figure BMI 1
how to have cells automatically fill when entering value in ref 2
How To Have A Cell Be Blank If... 2
Formula for If "" AND "" are true... 3
Use Formula to Replace A Cell 3
using formula or similar to paste maximum value in cell in excel 2 4

Back
Top