| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
help with simple formula
I am having trouble putting the following three conditions together in a
formula, each of the three conditions must be met: 1) if(or(A1:A7=D1) 2) if(or(B1:B7<=D2) 3) ((C1-C2)/E1=.10) I have tried the following but it is not working: =if(or(A1:A7=D1),if(or(B1:B7<=D2),((C1-C2)/E1=.10),G1,"")) I appreciate your help with this. Thanks. -- Shooter |
|
#2
|
|||
|
|||
|
http://www.excelforum.com/showthread.php?t=380105 http://www.excelforum.com/showthread.php?t=380106 -- olasa ------------------------------------------------------------------------ olasa's Profile: http://www.excelforum.com/member.php...o&userid=17760 View this thread: http://www.excelforum.com/showthread...hreadid=380109 |
| 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 | |||
Linear Mode
