INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!

Talk With Other Members
Be Notified Of Responses
To Your Posts
Keyword Search
One-Click Access To Your
Favorite Forums
Automated Signatures
On Your Posts
Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

LINK TO THIS FORUM!

Tek-Tips LinkedIn^® Group

Join our
LinkedIn^® Group!

Hook up with past and present colleagues and classmates quickly.

Partner With Us!

"Best Of Breed" Forums Add Stickiness To Your Site

(Download This Button Today!)

Feedback

"...your web site's great! I've been using this system for almost a year now and find it really, really helpful. The people have been helpful in answering just about any question you post in the forums..."

More...

Geography

Where in the world do Tek-Tips members come from?

Click Here To Find Out!

Tek-Tips Shirts!

Get your
Tek-Tips Forums
SWAG here!

Home > Forums > MIS/IT > Office Suites > Microsoft: Office Forum

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

Read More Threads Like This One

cwolfe (TechnicalUser)

14 Mar 00 9:30

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:
=IF(P8>B1,??????,??????)
My desired out put is combined numerical and text for example if P8 is 24 and B1 is 22.5 then output should be:
1.5 too high
and vice versa is B1 is larger than P8

Thanks for the help

Trunk (MIS)

14 Mar 00 10:07

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:

=IF(P8>B1,P8-B1&" too high",????)

Tom Thaden
thadents@usano.ksc.nasa.gov

cwolfe (TechnicalUser)

14 Mar 00 10:50

That worked just the way I wanted it, thanks

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Back To Forum

Back To Microsoft: Office