if-then-else construction in Excel formula

Upp3rd0G

if (a1 = 1 && b1 = 2)
{
c1 = 1;
}
elsif (a1 =2 && b1 = 3)
{
c1 = 2:
}

I tried to get the above in an Excel formula for field C1:

=IF((A1=1)*AND(B1=2);1;*OR(IF((A1=2)*AND(B1=3);2;999)))

It doesn't work. Somebody any idea?

__________________

• You can help us to help you even better. You can help fund our research
• Please read the rules
• Please detail your problem... What info do U provide? Try our Search... function
• Please read this for more info on audio copy protections

Upp3rd0G

Problem solved.

=IF(AND(A1=1;B1=2);"1";IF(AND(A1=2;B1=3);"2";IF(AND(A1=3;B1=4);"3";IF(AND(A1=4;B1=5);"4")) ))

Case closed.

__________________

• You can help us to help you even better. You can help fund our research
• Please read the rules
• Please detail your problem... What info do U provide? Try our Search... function
• Please read this for more info on audio copy protections

solskjaer

=ALS(EN(A1=1;B1=1);1;ALS(EN(A1=2;B1=3);2))
With English version of Excel:
als = if
en =and


[edit]
This is an English forum, no Dutch allowed!
Edited it for you this time.
[/edit]

rdgrimes

those parenthesis will get you every time

zoey90

i want to construct a formula.

CALCULATE THE TAX BASED ON 0.85% OF CURRENT SALARY IF CURRENT SALARY MORE THAN 25000.

how to construst above formula using IF.
can anyone help me?

seiwakai5378

is it possible for Excel to convert digits to words? for example 1,000.00 to One Thousand?

the ditch doctor

Yes it is.

=IF(A1=1000,"One Thousand","")

the ditch doctor

Is it possible to use a "if/then" formula to reference and list the contents another cell?
ie: =if a1=x then b1 = c1