conditional functions
 

does anyone know how to create a conditional formula with two conditions???

Hi
- choose formula
- enter something like
=AND(A1=1,B1=2)

--
Regards
Frank Kabel
Frankfurt, Germany

"j" schrieb im Newsbeitrag
...
does anyone know how to create a conditional formula with two
conditions???

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


"j" wrote:

does anyone know how to create a conditional formula with two conditions???