| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Formula with multiple IF'S
I would like to create a formula with mutiple "if's". Here's is how I have
the formula....Please let me know the correct way to phrase it to get my results. =IF(S3=Bank) and (E3 or F3=L), 1,0 I want it to meet a conditions in all 3 cells in order to assign a value of 1 if it meets them. 0 if it doesn't. Thanks!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Apply a simple formula to multiple rows? | New Users to Excel | |||
| Deleting multiple rows through a formula | Excel Discussion (Misc queries) | |||
| Problem with VBA returning the contents of a long formula. | Excel Discussion (Misc queries) | |||
| Formula to return cell contents based on multiple conditions | Excel Worksheet Functions | |||
| select multiple cell ranges in "sumif" formula? | Excel Worksheet Functions | |||
Threaded Mode
