Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Nested IF with OR Function
How do I accomplish this:
If a cell value 0 OR another cell value 0, then leave blank. If either contains a value, then calculate. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Nested IF with OR Function
Hi Trudy
Something like =IF(OR(A10,A20),"",B1+B2) Regards Roger Govier Trudy wrote: How do I accomplish this: If a cell value 0 OR another cell value 0, then leave blank. If either contains a value, then calculate. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Nested IF with OR Function
Here is what I tried:
=IF(OR(C60,D60),"",E5+C6+D6) But the result is the opposite of what I need. E5+C6+D6 is calculating with nothing in C6 or D6. I don't want it to calculate if either C6 or D6 are empty. Thank you, Roger. "Roger Govier" wrote: Hi Trudy Something like =IF(OR(A10,A20),"",B1+B2) Regards Roger Govier Trudy wrote: How do I accomplish this: If a cell value 0 OR another cell value 0, then leave blank. If either contains a value, then calculate. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Nested IF with OR Function
Hi Trudy
There must be something in C or D6. Try =IF(OR(ISNUMBER(C6),ISNUMBER(D6)),"",E5+C6+D6) Regards Roger Govier Trudy wrote: Here is what I tried: =IF(OR(C60,D60),"",E5+C6+D6) But the result is the opposite of what I need. E5+C6+D6 is calculating with nothing in C6 or D6. I don't want it to calculate if either C6 or D6 are empty. Thank you, Roger. "Roger Govier" wrote: Hi Trudy Something like =IF(OR(A10,A20),"",B1+B2) Regards Roger Govier Trudy wrote: How do I accomplish this: If a cell value 0 OR another cell value 0, then leave blank. If either contains a value, then calculate. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Nested IF with OR Function
Thanks, Roger - I figured out the problem. I had the "thens" switched.
The below is what works: =IF(OR(C60,D60),E5+C6-D6,"") "Roger Govier" wrote: Hi Trudy There must be something in C or D6. Try =IF(OR(ISNUMBER(C6),ISNUMBER(D6)),"",E5+C6+D6) Regards Roger Govier Trudy wrote: Here is what I tried: =IF(OR(C60,D60),"",E5+C6+D6) But the result is the opposite of what I need. E5+C6+D6 is calculating with nothing in C6 or D6. I don't want it to calculate if either C6 or D6 are empty. Thank you, Roger. "Roger Govier" wrote: Hi Trudy Something like =IF(OR(A10,A20),"",B1+B2) Regards Roger Govier Trudy wrote: How do I accomplish this: If a cell value 0 OR another cell value 0, then leave blank. If either contains a value, then calculate. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Nested IF with OR Function
Hi Trudy
Glad you got it sorted. As I drove off to the pub, I suddenly thought it was quite illogical. Why would you be wanting to add/subtract C6 and D6 if they were 0, but in the haste of answering, I didn't consider the facts. It's amazing how the thought of alcohol brings out the true logic<bg Regards Roger Govier Trudy wrote: Thanks, Roger - I figured out the problem. I had the "thens" switched. The below is what works: =IF(OR(C60,D60),E5+C6-D6,"") "Roger Govier" wrote: Hi Trudy There must be something in C or D6. Try =IF(OR(ISNUMBER(C6),ISNUMBER(D6)),"",E5+C6+D6) Regards Roger Govier Trudy wrote: Here is what I tried: =IF(OR(C60,D60),"",E5+C6+D6) But the result is the opposite of what I need. E5+C6+D6 is calculating with nothing in C6 or D6. I don't want it to calculate if either C6 or D6 are empty. Thank you, Roger. "Roger Govier" wrote: Hi Trudy Something like =IF(OR(A10,A20),"",B1+B2) Regards Roger Govier Trudy wrote: How do I accomplish this: If a cell value 0 OR another cell value 0, then leave blank. If either contains a value, then calculate. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Nested "If" Function | Excel Worksheet Functions | |||
undefined function error when creating xls pivot from mdb qry | Excel Worksheet Functions | |||
Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
Countif Function -Nested | Excel Discussion (Misc queries) | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions |