Logical Function Override

H

H. Massey

Is is possible to override the default value of true/false in a logical function? I want it to read pass for true and fail for false

Thanks
Heidi
 
P

Peo Sjoblom

No but you can use for instance an IF function

=IF(A1>2,"Pass","Fail")

--

Regards,

Peo Sjoblom

H. Massey said:
Is is possible to override the default value of true/false in a logical
Click to expand...
function? I want it to read pass for true and fail for false.
 
J

JE McGimpsey

You can always wrap the condition in an IF() statement:

=IF(<condition>, "Pass", "Fail")
 
H

H. Massey

Thanks guys

Heid

----- Peo Sjoblom wrote: ----

No but you can use for instance an IF functio

=IF(A1>2,"Pass","Fail"

--

Regards

Peo Sjoblo

H. Massey said:
Is is possible to override the default value of true/false in a logica
Click to expand...
function? I want it to read pass for true and fail for false
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word macro that can call cells out of Excel for a find and replace 0
Change a great number of words in word files, with a macro as short as possible. 5
Macro to Select text from a point given to a specific word 2
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
Format within a Function 1
Loop through pages and insert header image 0
MATCH not working in IF statement 6
VBA for Dependents shortcut menu 0

Top