| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
conditional functions
does anyone know how to create a conditional formula with two conditions???
|
|
#2
|
|||
|
|||
|
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??? |
|
#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 "j" wrote: does anyone know how to create a conditional formula with two conditions??? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Determine cells that drive conditional formatting? | Excel Discussion (Misc queries) | |||
| Conditional formatting not available in Excel | Excel Discussion (Misc queries) | |||
| Conditional functions | Excel Worksheet Functions | |||
| Adding more than three Conditions to 'Conditional Formatting' | Excel Discussion (Misc queries) | |||
| Conditional Formatting | Excel Worksheet Functions | |||
Linear Mode
