This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Grateful for anyone's help.
Why does the If Formula: =ifE9"",=(B9+D11)-9 , while correctly displaying nothing when E9 is blank, simply displays the formula (ie. =(B9+D11)-9 ) not its outcome, when E9 has data entered.
I am sure it is very simple. But I've tried everything I can find on-line, without success.
Thanks.
David Mills
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
The "formula" as you have entered it above is not a formula.
Perhaps this is what you intended to enter:
=IF(E9="","",B9+D11-9)
Kevin