Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I need a formula that will give me results as follows:
If S1=Bank and E1 or F1=L, 1,0 The response to S1 must be Bank, but either E1 or F1 can be L to count as 1. Both E1 and F1 don't have to meet the condition, thus the or Thanks!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |