OR Function

R

RIC

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
 
B

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
 

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

IF Statement on multiple levels 6
Copy condtional formatting in XL2007 for Windows 1
Newbie Help - IF Yes No Function 0
Using IF, AND and OR functions together 2
Use TODAY() function as the criteria in a SUMIF formula 1
Function to Return a Date Value Q 4
OLD PROBLEM without SOLUTION , part || 1
Continuation to equivalent for formula - to Mr. Harlan Grove (and notonly...) 1

Top