Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
How can I mix numerical and text output in an excel formula?
That worked just the way I wanted it, thanks- cwolfe
- Post #3
- Forum: Microsoft: Office
-
How can I mix numerical and text output in an excel formula?
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>B1,??????,??????)<br> My desired out put is combined numerical and text for example if P8 is 24 and B1 is 22.5 then output...- cwolfe
- Thread
- Replies: 2
- Forum: Microsoft: Office
