Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
simple formula
I am having trouble with "and" , "or" in my formulas.
If I want one of c1:c4 to be true is this the formula to use =if((c1:c4)d1),g1,"") or should I use =if(or(c1:c4)d1),g1,""). Neither one of these formulas seems to work. In other words, I am trying to write a shorter formula for the following: =if(c1d1 or c2d1 or c3d1 or c4d1, G1,"") Thanks for help with this simple formula. |
#2
|
|||
|
|||
Try one of these:
normally entered: =IF(OR(C1D1,C2D1,C3D1,C4D1),G1,"") array entered with the key combo of CTRL,SHIFT,ENTER: =IF(OR(C1:C4D1),G1,"") Biff "Brian" wrote in message ... I am having trouble with "and" , "or" in my formulas. If I want one of c1:c4 to be true is this the formula to use =if((c1:c4)d1),g1,"") or should I use =if(or(c1:c4)d1),g1,""). Neither one of these formulas seems to work. In other words, I am trying to write a shorter formula for the following: =if(c1d1 or c2d1 or c3d1 or c4d1, G1,"") Thanks for help with this simple formula. |
#3
|
|||
|
|||
=IF(SUMPRODUCT(--(C1:C4D1))0,G1,"") Mangesh -- mangesh_yadav ------------------------------------------------------------------------ mangesh_yadav's Profile: http://www.excelforum.com/member.php...o&userid=10470 View this thread: http://www.excelforum.com/showthread...hreadid=379588 |
#4
|
|||
|
|||
and will return true if all arguements are true,or will return true if only
one argument is true -- paul remove nospam for email addy! "Brian" wrote: I am having trouble with "and" , "or" in my formulas. If I want one of c1:c4 to be true is this the formula to use =if((c1:c4)d1),g1,"") or should I use =if(or(c1:c4)d1),g1,""). Neither one of these formulas seems to work. In other words, I am trying to write a shorter formula for the following: =if(c1d1 or c2d1 or c3d1 or c4d1, G1,"") Thanks for help with this simple formula. |
#5
|
|||
|
|||
Try
=if(or(c1:c4)d1,g1,"") but commit the formula by pressing Ctrl-Shift-Enter to make it an array formula "Brian" wrote: I am having trouble with "and" , "or" in my formulas. If I want one of c1:c4 to be true is this the formula to use =if((c1:c4)d1),g1,"") or should I use =if(or(c1:c4)d1),g1,""). Neither one of these formulas seems to work. In other words, I am trying to write a shorter formula for the following: =if(c1d1 or c2d1 or c3d1 or c4d1, G1,"") Thanks for help with this simple formula. |
#6
|
|||
|
|||
try
=if(or(C1D1,C2D1,C3D1,C5D1),G1,"") or =if(max(C1:C4)D1,G1,"") "Brian" wrote: I am having trouble with "and" , "or" in my formulas. If I want one of c1:c4 to be true is this the formula to use =if((c1:c4)d1),g1,"") or should I use =if(or(c1:c4)d1),g1,""). Neither one of these formulas seems to work. In other words, I am trying to write a shorter formula for the following: =if(c1d1 or c2d1 or c3d1 or c4d1, G1,"") Thanks for help with this simple formula. |
#7
|
|||
|
|||
This may be a second response but
try =if(or(C1D1,C2D1,C3D1,C4D1),G1,"") or =if(max(C1:C4)D1,G1,"") "Brian" wrote: I am having trouble with "and" , "or" in my formulas. If I want one of c1:c4 to be true is this the formula to use =if((c1:c4)d1),g1,"") or should I use =if(or(c1:c4)d1),g1,""). Neither one of these formulas seems to work. In other words, I am trying to write a shorter formula for the following: =if(c1d1 or c2d1 or c3d1 or c4d1, G1,"") Thanks for help with this simple formula. |
#8
|
|||
|
|||
"Brian" wrote in message
... I am having trouble with "and" , "or" in my formulas. If I want one of c1:c4 to be true is this the formula to use =if((c1:c4)d1),g1,"") or should I use =if(or(c1:c4)d1),g1,""). Neither one of these formulas seems to work. In other words, I am trying to write a shorter formula for the following: =if(c1d1 or c2d1 or c3d1 or c4d1, G1,"") Thanks for help with this simple formula. How about =if (MAX(c1:c4)d1,g1,"") |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Howdo U copy a formula down a column, that uses data in another w. | Excel Worksheet Functions | |||
Howdo U copy a formula down a column, that uses data in another w. | Excel Worksheet Functions | |||
Excel Miscalculates simple formula..Help!! | Excel Worksheet Functions | |||
Relative Indirect Formula Referencing? | Excel Worksheet Functions | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions |