if-then-else construction in Excel formula - Club CDFreaks

*Upp3rd0G* · 31-10-2002

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?

*Upp3rd0G* · 31-10-2002

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.

solskjaer · 31-10-2002

=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* · 31-10-2002

those parenthesis will get you every time

zoey90 · 1 Week Ago

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?

31-10-2002	#1 (permalink)
Upp3rd0G CDFreaks Resident Join Date: Oct 2001 Location: NL Posts: 2,108	if-then-else construction in Excel formula <a href='http://adstats.cdfreaks.com/www/delivery/ck.php?n=a13febf7&cb=INSERT_RANDOM_NUMBER_HERE' target='_blank'><img src='http://adstats.cdfreaks.com/www/delivery/avw.php?zoneid=30&cb=INSERT_RANDOM_NUMBER_HERE&n=a13febf7' border='0' alt='' /></a> 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

31-10-2002	#2 (permalink)
Upp3rd0G CDFreaks Resident Join Date: Oct 2001 Location: NL Posts: 2,108	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

31-10-2002	#3 (permalink)
solskjaer New on Forum Join Date: Oct 2002 Posts: 10	Possible solution =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] Last edited by Da_Taxman; 31-10-2002 at 18:27.

1 Week Ago	#5 (permalink)
zoey90 New on Forum Join Date: Jun 2008 Posts: 1	Re: if-then-else construction in Excel formula 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?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Construction Destruction	kalas	Copy Protection List	5	23-11-2007 07:30
Stupid construction	Bloodstar007	CD Freaks Living Room	1	19-11-2004 10:24
Lite-On -- flimsy construction?	BlueWinterWaves	LiteOn / PLDS/ Sony Burner	29	05-08-2002 23:08
Serial/Crack ScreenSaver Construction Set aub...	Administr8or	Dutch: De Woonkamer	4	05-06-2000 18:01

Commercial message
<a href='http://adstats.cdfreaks.com/www/delivery/ck.php?n=ac816a32&cb=INSERT_RANDOM_NUMBER_HERE' target='_blank'><img src='http://adstats.cdfreaks.com/www/delivery/avw.php?zoneid=29&cb=INSERT_RANDOM_NUMBER_HERE&n=ac816a32' border='0' alt='' /></a>

31-10-2002	#4 (permalink)
rdgrimes Retired Moderator Join Date: Jun 2002 Location: Deadwood Posts: 11,449	those parenthesis will get you every time