Use of the "OR" function

  • Thread starter Thread starter GND
  • Start date Start date
G

GND

I am trying to use two logical conditions in writing an
IF,THEN,ELSE formula in Excel that does the following: IF
(C500>C499) OR (O500>C500) THEN SET IT TO 0, OTHERWISE DO
THE FOLLOWING (C500-O500)*30. Here's the formula that
I've used but it doesn't work: =(IF((C500>C499)OR
(O500>C500)),0,(C500-O500)*30)

The bottom line is that I'm not sure how to use the OR
function. Can anyone tell me what I'm doing wrong?
Thanks for your help!
 
=(IF(OR(C500>C499,O500>C500),0,(C500-O500)*30)

--
Best Regards
Leo Heuser
Excel MVP

Followup to newsgroup only please.
 
Give a man a fire and he will be warm the rest of the day
Set a man on fire and he will be warm the rest of his life
 
Im a novice at this, but had a similar problem with conditional
formulas. I think I may have what you are looking for.

=if(or(C500>C499,O500>C500),(0),30*(C500-O500))


Something that helped me greatly was clicking on my formula in the
formula window. As you move the cursor back and forth over the formula,
it displays what that portion of the formula does. You may already know
that.

Let me know if that formula works for you.
 
So, that's how you cook the fish.

Tom Ogilvy said:
Give a man a fire and he will be warm the rest of the day
Set a man on fire and he will be warm the rest of his life
Click to expand...
 
Back
Top