Thread: Calculating from IF statement

I have data pulling through from one main page (tab 1) in order to avoid having to retype the same entry everyday (into tabs 2-25).

I need to calculate new information (into a different cell on tab 2) off of the data pulled through, but when I try to reference the cell with the pulled through data it will not compute. Is there a way to tell Excel to look at the actual number in the cell and not the "pull through" formula it is using? I can attach the document if you need it to make more sense, but it is really confusing to look at.
Thanks,
Lisa

Attach the document and specifically tell us what cell to look at and what it should be pulling.