How can I mix numerical and text output in an excel formula?

[cwolfe]

I am trying to use excel 97 to provide a direct direction to an operator as to if a process is too high or too low. The formula I am trying to use is this:<br>
=IF(P8&gt;B1,??????,??????)<br>
My desired out put is combined numerical and text for example if P8 is 24 and B1 is 22.5 then output should be:<br>
1.5 too high<br>
and vice versa is B1 is larger than P8<br>
<br>
Thanks for the help

 

[Trunk]

You didn't say what you wanted to do if P8 wasn't greater than B1, but the following will work for the 'true' section of the If statement if P8 is greater than B1:<br>
<br>
=IF(P8&gt;B1,P8-B1&&quot; too high&quot;,????) <p>Tom Thaden<br><a href=mailto:thadents@usano.ksc.nasa.gov>thadents@usano.ksc.nasa.gov</a><br><a href= > </a><br>

 

[cwolfe]

That worked just the way I wanted it, thanks