Need help with formula that references cell that has reference to another worksheet. not showing as blank

[dc103034]

I have a spreadsheet that displays results of a calculation worksheet, both in the same workbook. Status should only show when the "actual" cell is populated with a number/result from the calculation page.


the status cell uses this formula "=IF(H16="","",IF(H16>=H15,1,0))"
the Actual cell uses this formula "='2016 Calculation tab'!H28"
Since the "actual" cell is not really blank, I get a 1 displayed when I should not get any display. The 1 and 0 are conditional formation that displays an icon Red/green.
Plan
Actual
Status 1

it is interesting that I've used this formula without issue in the past and now in the new worksheet, it is not displaying correctly. In fact, some rows do not display anything and others do display. yet all are using a version of the same formula in Status and Actual

 

[JLGWhiz]

Try it like this

=If(H16>0,IF(H16>=H15,1,0),"")

 

[dc103034]

Try it like this

=If(H16>0,IF(H16>=H15,1,0),"")

So, thanks
However, it did not work
this is the show formula view
[TABLE="width: 600"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]Plan[/TD]
[TD]='2016 Calculation tab'!H22[/TD]
[/TR]
[TR]
[TD]Actual[/TD]
[TD]='2016 Calculation tab'!H25[/TD]
[/TR]
[TR]
[TD]Status[/TD]
[TD]=IF(H13>=0,IF(H13>=H12,1,0),"")



[/TD]
[/TR]
</tbody>[/TABLE]



yet, the cell is still has no results in the calculation tab and therefore not showing any result in the display tab, but because the cell reference is there, the status is still displaying a calculation result of 1.

[TABLE="width: 300"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]Plan[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Actual[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Status[/TD]
[TD]1[/TD]
[/TR]
</tbody>[/TABLE]