Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use of the "OR" function
I am trying to use two logical conditions in writing an
IF,THEN,ELSE formula in Excel that does the following: IF (C500C499) OR (O500C500) 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((C500C499)OR (O500C500)),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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use of the "OR" function
=(IF(OR(C500C499,O500C500),0,(C500-O500)*30)
-- Best Regards Leo Heuser Excel MVP Followup to newsgroup only please. "GND" skrev i en meddelelse ... I am trying to use two logical conditions in writing an IF,THEN,ELSE formula in Excel that does the following: IF (C500C499) OR (O500C500) 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((C500C499)OR (O500C500)),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! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use of the "OR" function
Suggest looking in HELP index for OR function syntax.
"GND" wrote in message ... I am trying to use two logical conditions in writing an IF,THEN,ELSE formula in Excel that does the following: IF (C500C499) OR (O500C500) 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((C500C499)OR (O500C500)),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! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use of the "OR" function
Thanks much Leo!!!
-----Original Message----- =(IF(OR(C500C499,O500C500),0,(C500-O500)*30) -- Best Regards Leo Heuser Excel MVP Followup to newsgroup only please. "GND" skrev i en meddelelse ... I am trying to use two logical conditions in writing an IF,THEN,ELSE formula in Excel that does the following: IF (C500C499) OR (O500C500) 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((C500C499)OR (O500C500)),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! . |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use of the "OR" function
You're welcome.
skrev i en meddelelse ... Thanks much Leo!!! |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use of the "OR" function
What's the old saying about giving a man a fish?
"Don Guillett" wrote in message ... Suggest looking in HELP index for OR function syntax. "GND" wrote in message ... I am trying to use two logical conditions in writing an IF,THEN,ELSE formula in Excel that does the following: IF (C500C499) OR (O500C500) 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((C500C499)OR (O500C500)),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! |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use of the "OR" function
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 -- Regards, Tom Ogilvy Don Guillett wrote in message ... What's the old saying about giving a man a fish? "Don Guillett" wrote in message ... Suggest looking in HELP index for OR function syntax. "GND" wrote in message ... I am trying to use two logical conditions in writing an IF,THEN,ELSE formula in Excel that does the following: IF (C500C499) OR (O500C500) 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((C500C499)OR (O500C500)),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! |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use of the "OR" function
LOL! Hadn't heard that one before, Tom.
Regards, Vasant. "Tom Ogilvy" wrote in message ... 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 -- Regards, Tom Ogilvy Don Guillett wrote in message ... What's the old saying about giving a man a fish? "Don Guillett" wrote in message ... Suggest looking in HELP index for OR function syntax. "GND" wrote in message ... I am trying to use two logical conditions in writing an IF,THEN,ELSE formula in Excel that does the following: IF (C500C499) OR (O500C500) 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((C500C499)OR (O500C500)),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! |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use of the "OR" function
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(C500C499,O500C500),(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. ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ |
#10
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use of the "OR" function
So, that's how you cook the fish.
"Tom Ogilvy" wrote in message ... 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 -- Regards, Tom Ogilvy Don Guillett wrote in message ... What's the old saying about giving a man a fish? "Don Guillett" wrote in message ... Suggest looking in HELP index for OR function syntax. "GND" wrote in message ... I am trying to use two logical conditions in writing an IF,THEN,ELSE formula in Excel that does the following: IF (C500C499) OR (O500C500) 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((C500C499)OR (O500C500)),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! |
#11
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use of the "OR" function
The error is on the OR function Try =(IF( OR (O500C500;C500C499) ),0,(C500-O500)*30 ----------------------------------------------- ~~ Message posted from http://www.ExcelTip.com ~~View and post usenet messages directly from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Text "comparison" operator for "contains" used in an "IF" Function | Excel Worksheet Functions | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel |