| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Creating a specific formula
I need to create a formula that checks to see that the text in 2 different
cells are supposed to be what the formula specifies before it calculates the sum of 2 other cells ie.. cell A1 = "Last" cell B1 = "First" cell C1 = "25" cell D1 = "75" The formula needs to be sure that cells a1 and b1 contain those exact words otherwise it will give a response of "0"....but if they do contain those exact words than the response would be the sum of cells c1 and d1....."100" How do I write this formula correctly? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating a formula using absolute referencing - I think!! | Excel Worksheet Functions | |||
| Creating Formula using check boxes | Excel Discussion (Misc queries) | |||
| Help creating a formula, pulling from a set of static numbers. | Excel Worksheet Functions | |||
| How do I create a formula to add values from specific fields? | Excel Worksheet Functions | |||
| How do I create a formula to add values from specific fields? | Excel Worksheet Functions | |||
Threaded Mode
