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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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? |
#4
|
|||
|
|||
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. |
Reply |
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 |