Logical Function Override

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
You can always wrap the condition in an IF() statement:

=IF(<condition>, "Pass", "Fail")
 
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
 
Depending on your application, try using the IF function (e.g: if(A1>=75,"Pass","Fail") If the value in cell A1 is greater than or equal to 75 then it would return Pass. If it was less than 75 it would return Fail

----- H. Massey wrote: ----

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
 

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

MATCH not working in IF statement 6
Format within a Function 1
Find certain text in a cell 3
Numerical value of logicals 4
an IF function that can take no action? 5
logical function bug? 4
How do i trouble shoot an IF function 2
function to populate a cell where formula is NOT located 6

Back
Top