OR Function

[Guest]

Is there a way to get =OR((F5>0),(E5>0)) to return a value of "1" or text other than TRUE or FALSE

Thank you, RIC

 

[Frank Kabel]

Hi
try
=IF(OR(F5>0,E5>0),1,"not true")

 

[Rita Palazzi]

=IF(OR((F3>0),(E3>0)),1,0)

 

[Bernard V Liengme]

=OR((F5>0),(E5>0)) *1 will give 1 or 0
so will =OR(F5>0,E5>0) *1
and =IF(=OR(F5>0,E5>0),"Right", "Wrong") will give other text
Bernard