Creating a specific formula

G

Guest

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top