excell help

[ingust]

can anybody help me with a formula this is what i want but it wont run, the result is to be in c3

=if(and(a2=1000,a2=1100,b2=1000,b2=1200),0,12,6,-6,"")

[sentabool]

can you describe in words what you want - the formula doesn't make sense

[ingust]

if a2=1000 and b2=1000 then c2=0
if a2=1000 and b2=1100 then c2=6
if a2=1000 and b2=1200 then c2=12
if a2=1100 ans b2=1200 then c2=6

this is what i want to do but excel
wont do it i need it as one formula , i havn't got macros available i need to know if it is possible

[sentabool]

Try this in cell c2 - a nested if statement: -

=IF(AND(A2=1000,B2=1000),0,IF(AND(A2=1000,B2=1100),6,IF(AND(A2=1000,B2=1200),12,IF(AND(A2=1100,B2=1200),6,""))))

[ingust]

it works, thank you very much ,is there any limit to the length of the formula i can put in one cell,what i'am trying to do is put a speed rating program which is written in basic into excel and that requires distances from 1000 to 2000 metres which would have to written the way you have shown me.I have bought a couple of books on excel but none seem to have examples of this kind of forumla can you recommend any ?
Any how thanks again for the help

[zorro]

Ingust,
The SUMPRODUCT function will probably do what you want. I use it to get Par times for distances at different tracks.
Rather than try to explain it here I recommend this link:
http://www.excel-vba.com/e-formula-sumproduct.htm

[ingust]

thanks Zorro for the site ,i will probably have to buy the book or software ,the other way works but takes up to much space with the formula