Calculating Formulas From Cells with Formulas

[Liverpool1959]

I pull 2 Cells of Data to the YTD Tab. It works. But there is a 3rd cell trying to calclate a ratio using those cells.

In the May tab the Formula is pull ing from cells with numbers

In the YTD Tab, the cell is either pulling data from the May tab that is a formula, or it's pulling from 2 cells in the YTD tab that are also formulas

So I guess the question is, how do you do a formula pulling info from cells that are formulas

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel-questions/1097609-ytd-tab-data.html

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).