Home |
Search |
Today's Posts |
#1
|
|||
|
|||
help with simple formula
try
=if(and(max(A1:A7)=D1,Min(B1:B7)<=D2,(C1-C2)/E1=0.1),G1,"") "Shooter" wrote: 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
|
|||
|
|||
If it has to be ALL three conditions, then
=IF(AND(MAX(A1:A7)=D1,MIN(B1:B7)<=D2,(C1-C2)/E1=.10),result if true, result if false) "Shooter" wrote: 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 |
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 |