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. |
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 |