Using IF function with multiple conditions

Question

I have an Excel report where I have to convert money (Column O in the picture) into EUR currency: enter image description here

So far I have been using the IF function, but here the pattern is a bit different. Instead of

=IF(Condition;"true";"false")

I need rather

=IF(P2='EUR';O2);IF(P2='USD';O2*0,78);IF(P2='GBP';O2*1,25);

Just it does not work as it's not a correct Excel expression. Any help ?

Luke · Accepted Answer · 2015-01-07 09:21:53Z

2

Something like this...

=IF(P2='EUR';O2;IF(P2='USD';O2*0,78;IF(P2='GBP';O2*1,25;NA())))

edited Jan 7, 2015 at 9:21

Luke

11.5k43 gold badges63 silver badges70 bronze badges

answered Jan 7, 2015 at 8:42

Tony

1,6751 gold badge11 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Antares42 · Accepted Answer · 2015-01-07 08:41:51Z

2

You'll have to nest the IF function calls, i.e.

IF(Condition1;Result1;IF(Condition2;Result2;If(Condition3;Result3;SomeDefault)))

Example here:

enter image description here

answered Jan 7, 2015 at 8:41

Antares42

1,4561 gold badge17 silver badges46 bronze badges

Comments

Mohammed · Accepted Answer · 2015-01-07 08:54:20Z

2

First arrange a currency values table versus euro for example I did that in sheet 2 on below image

enter image description here

then you can use the formula: =IF(ISNA(VLOOKUP(P2,Sheet2!$A$1:$B$4,2,0)*O2),"Incorrect urrency",VLOOKUP(P2,Sheet2!$A$1:$B$4,2,0)*O2)

answered Jan 7, 2015 at 8:54

Mohammed

3131 silver badge6 bronze badges

2 Comments

Antares42 Over a year ago

This is actually a pretty clever solution. Very relational-database-like. Love it.

user2824073 Over a year ago

Already chosen the right answer, thanks anyway for sharing the tip!

facundofarias · Accepted Answer · 2015-01-07 08:55:44Z

1

Right. I don't have excel, but I did it on Google Spreadsheets, and it works. So what you have to do is to nest the conditions, such as:

=IF(B1="EUR";A1;IF(B1="GBP";A1*1,25;A2*0,78))

So you will get something like:

Sample

Hope this helps!

edited Jan 7, 2015 at 8:55

answered Jan 7, 2015 at 8:43

facundofarias

3,04933 silver badges27 bronze badges

Collectives™ on Stack Overflow

Using IF function with multiple conditions

4 Answers 4

Comments

Comments

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related