software

I am creating a spreadsheet for solving quot;Solution of Triangles).
For the most part everything works well except for one situation.

In: B51 (Angle A)--------------J51 (Angle B)
So in J51 the formula is quot;=B51-90quot;
It works as long as there is data in B51. But when the cell is empty the
answer I get is 90 with the degree symbol because the cell is formated to
show the answer with the degree symbol.
How can this formula in J51 be modified to show an empty cell when B51 has
no input yet?

Many Thanks in advance.
Serge

J51 should have read quot;=90-B51quot;

quot;Sergequot; wrote:

gt; I am creating a spreadsheet for solving quot;Solution of Triangles).
gt; For the most part everything works well except for one situation.
gt;
gt; In: B51 (Angle A)--------------J51 (Angle B)
gt; So in J51 the formula is quot;=B51-90quot;
gt; It works as long as there is data in B51. But when the cell is empty the
gt; answer I get is 90 with the degree symbol because the cell is formated to
gt; show the answer with the degree symbol.
gt; How can this formula in J51 be modified to show an empty cell when B51 has
gt; no input yet?
gt;
gt; Many Thanks in advance.
gt; Serge

Hi Serge!

Try this:

=IF(B51=quot;quot;,quot;quot;,B51-90)

Biff

quot;Sergequot; gt; wrote in message
...
gt;I am creating a spreadsheet for solving quot;Solution of Triangles).
gt; For the most part everything works well except for one situation.
gt;
gt; In: B51 (Angle A)--------------J51 (Angle B)
gt; So in J51 the formula is quot;=B51-90quot;
gt; It works as long as there is data in B51. But when the cell is empty the
gt; answer I get is 90 with the degree symbol because the cell is formated to
gt; show the answer with the degree symbol.
gt; How can this formula in J51 be modified to show an empty cell when B51 has
gt; no input yet?
gt;
gt; Many Thanks in advance.
gt; Serge
Hello Biff,
You always seem to be there for my rescue.
Thank you so much.
Serge J.

quot;Biffquot; wrote:

gt; Hi Serge!
gt;
gt; Try this:
gt;
gt; =IF(B51=quot;quot;,quot;quot;,B51-90)
gt;
gt; Biff
gt;
gt; quot;Sergequot; gt; wrote in message
gt; ...
gt; gt;I am creating a spreadsheet for solving quot;Solution of Triangles).
gt; gt; For the most part everything works well except for one situation.
gt; gt;
gt; gt; In: B51 (Angle A)--------------J51 (Angle B)
gt; gt; So in J51 the formula is quot;=B51-90quot;
gt; gt; It works as long as there is data in B51. But when the cell is empty the
gt; gt; answer I get is 90 with the degree symbol because the cell is formated to
gt; gt; show the answer with the degree symbol.
gt; gt; How can this formula in J51 be modified to show an empty cell when B51 has
gt; gt; no input yet?
gt; gt;
gt; gt; Many Thanks in advance.
gt; gt; Serge
gt;
gt;
gt;

You're welcome. Thanks for the feedback!

Biff

quot;Sergequot; gt; wrote in message
...
gt; Hello Biff,
gt; You always seem to be there for my rescue.
gt; Thank you so much.
gt; Serge J.
gt;
gt; quot;Biffquot; wrote:
gt;
gt;gt; Hi Serge!
gt;gt;
gt;gt; Try this:
gt;gt;
gt;gt; =IF(B51=quot;quot;,quot;quot;,B51-90)
gt;gt;
gt;gt; Biff
gt;gt;
gt;gt; quot;Sergequot; gt; wrote in message
gt;gt; ...
gt;gt; gt;I am creating a spreadsheet for solving quot;Solution of Triangles).
gt;gt; gt; For the most part everything works well except for one situation.
gt;gt; gt;
gt;gt; gt; In: B51 (Angle A)--------------J51 (Angle B)
gt;gt; gt; So in J51 the formula is quot;=B51-90quot;
gt;gt; gt; It works as long as there is data in B51. But when the cell is empty
gt;gt; gt; the
gt;gt; gt; answer I get is 90 with the degree symbol because the cell is formated
gt;gt; gt; to
gt;gt; gt; show the answer with the degree symbol.
gt;gt; gt; How can this formula in J51 be modified to show an empty cell when B51
gt;gt; gt; has
gt;gt; gt; no input yet?
gt;gt; gt;
gt;gt; gt; Many Thanks in advance.
gt;gt; gt; Serge
gt;gt;
gt;gt;
gt;gt;