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?

One way

Put in E1:

=IF(AND(TRIM(A1)="Last",TRIM(B1)="First"),SUM(C1:D 1),0)

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"booroni" wrote in message
...
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?

That worked perfectly....thank you. Thanx for the fast response too.

"Max" wrote:

One way

Put in E1:

=IF(AND(TRIM(A1)="Last",TRIM(B1)="First"),SUM(C1:D 1),0)

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"booroni" wrote in message
...
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?

You're welcome !
Thanks for the feedback

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"booroni" wrote in message
...
That worked perfectly....thank you. Thanx for the fast response too.