using values from another sheet

[badmullah]

2nd sheet is accessing values from 'Effort by phase' sheet
in the 2nd sheet
I have some cells that include values form the first sheet

CELL F10 ='Effort by Phase'!D11
CELL G10 ='Effort by Phase'!E11
CELL H10 ='Effort by Phase'!F11


Then the final cell is
=IF(SUM(G10:H10)>0,G10/SUM(G10:H10), 0)

Now I want to come up with a formula to calclulate the above directly from the 2nd sheet bypassing having any F , G or H Cell to contain any values

I tried to use
=IF(('Effort by Phase'!E11+'Effort by Phase'!F11)>0,!'Effort by Phase'E11/('Effort by Phase'!E11+'Effort by Phase'!F11), 0)
to just have one cell calculating a number from the other sheet without having anything in Cell F10,G10 or H10 directly

but i m getting getting this Error

Theresa problem with this formula
Not trying to type a formula ?

Please let me know what the solution is

[ORoos]

Hi there,

Try: =IF('Effort by Phase'!E11+'Effort by Phase'!F11>0,'Effort by Phase'!E11/('Effort by Phase'!E11+'Effort by Phase'!F11),0)

[badmullah]

thank you it did it