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
 
Back
Top