does anyone know how to create a conditional formula with two conditions???
F Frank Kabel Dec 9, 2004 #2 Hi - choose formula - enter something like =AND(A1=1,B1=2) -- Regards Frank Kabel Frankfurt, Germany j said: does anyone know how to create a conditional formula with two Click to expand... conditions???
Hi - choose formula - enter something like =AND(A1=1,B1=2) -- Regards Frank Kabel Frankfurt, Germany j said: does anyone know how to create a conditional formula with two Click to expand... conditions???
K K.S.Warrier Dec 10, 2004 #3 Hi, Try this,if it suites you. If A1 contains one value & B1 contains another value,then in C1 =if(A1>=4,if(A1<15,B1,"")) ie,if A1 is >=4 & <15, value will be B1 otherwise ""(blank) Thank you, K.S.Warrier
Hi, Try this,if it suites you. If A1 contains one value & B1 contains another value,then in C1 =if(A1>=4,if(A1<15,B1,"")) ie,if A1 is >=4 & <15, value will be B1 otherwise ""(blank) Thank you, K.S.Warrier
