MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Complicated Formula Precedents


Posted by Duncan on December 05, 2001 4:25 AM

I have a complicated formula
=OFFSET(Date.Reference,MATCH($B4,Data.Table)+IF(E4="P",5,IF(E4="S",4,3))-1,COLUMN(E6)-2)
Where the Named Ranges Data.Reference and Data.Table are in another worksheet.
I think the formula points to the correct cell but am not sure.
What I would like is to be able to ask excel what cell it believes this formula points to.
Normal Precendents route does not work as it just shows what the constituent cells that make up the formula are and not what the final cell references is.

Can anyone help?!
Cheers
D.


Posted by Aladin Akyurek on December 05, 2001 10:08 AM

Duncan --

You can go to the Formula Bar and hit F9 after selecting parts of your formula to see what it computes. By the way, I suppose your Data.Table is a 1-row or 1-column table.

Hope this helps.

Aladin

========

Posted by Duncan on December 11, 2001 5:02 AM

Thanks Aladin,
Yes Data.Table is 1-column. Does this make a difference
Cheers
D.