OR function

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

Guest

Can someone give me an OR argument that returns a numberical or text result other than TRUE or FALSE? I can do it with IF arguments, like =IF((F4>10%),"1"), or =IF((F5>10%),"Sell") but not with =OR. If possible, please give me an example, and also an example of combining OR and IF. Thank you. RIC
 
Hi Ric
What about:

=IF(OR(F4>10%,F5>10%),"1","Sell")

Regards
Michael
-----Original Message-----
Can someone give me an OR argument that returns a
Click to expand...
numberical or text result other than TRUE or FALSE? I can
do it with IF arguments, like =IF((F4>10%),"1"), or =IF
((F5>10%),"Sell") but not with =OR. If possible, please
give me an example, and also an example of combining OR
and IF. Thank you. RIC
 
Back
Top