Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Nesting Functions
I want to use two criterias for an answer?? If Column A contains a 1 and
Column B says Yes then return a 1 But if column B is blank return 0.. Then at the same time if column A contains anything 1 and Column B says Yes return a 2 but if column B is blank return zero Thanks For any suggestions M |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What is the syntax for nesting functions such as IF AND? | Excel Worksheet Functions | |||
# of Functions per cell | Excel Worksheet Functions | |||
PivotTable canned functions | Excel Discussion (Misc queries) | |||
nesting 18 x functions | Excel Worksheet Functions | |||
How to load Engineering Functions into the Fx function wizard? | Excel Worksheet Functions |