if/else statements

[turnej]

Hi I am trying to complete a formula whereby I have four columns, of these four the first 3 will only ever had 1 completed so lets say its column a,b or c there will only ever be a 1 in one of these columns I then need to determine if there is a 1 in column d,

so basically the formula would in basic terms be something like this:

if d1=1 and a1 = 1 then 650, if d1 and b1 then 700, if d1 and c1 then 350

I would need this to be for all cells in the columns and totals at the bottom?

Is this possible and if so any pointers on how I go about it?

Hope I have explained this correctly

[ConneXionLost]

How about:

Please Login or Register  to view this content.

Cheers,

[FloMM2]

turnej,
Here is another solution:

A B C D E
"= IF(AND(D1=1,A1=1),650,(IF(AND(D1=1,B1=1),700,(IF(AND(D1=1,C1=1),350,"?")))))"

Type the formula without the first and last " marks.
hth

[turnej]

Hi,

Thanks very much for your reply on this can you possibly explain this to me slightly as I am a complete novice on excel but would love to have an understanding so I can begin to write my own formula etc

[ChemistB]

What both are using above are Nested If statements. Flo's formula more closely mimics how you asked the question using the AND function. i.e. the first part of that formula would read "If Both D1 =1 and A1 = 1 then cell = 650, otherwise ....."
ConneXion simplifies this a bit removing the repetitive task of looking at D1 by separating that out into the initial IF statement like so
If it's true that D1 = 1, then if A1 = 1.. other conditions...., otherwise leave blank ("")

Here's a short tutorial on Nested IF statements. You can google for more.

http://spreadsheets.about.com/od/tip.../nested_if.htm
Hope that helps.

[turnej]

that's brilliant thanks all