• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

If condition with multiple argument

V

Vishal.jagani

New Member
Hello all
I have issue in If() with multiple condition
actually I know Ti's not big deal but I am confused now

There is column E has different numbers
and output should be "massages" in column H
Exa:
Column E Column H(output)
0.00 - "Simple charge 5,60 Euro"
0,00 - "Simple charge 5,60 Euro"
5,60 or 5.60 - "simple charge 5,60 Euro"
8,00 or 8.00 - "simple charge 5,60 Euro"
10,95 or 10.95- "Standard 14,95 Euro"
24,95 or 24.95 - "DHL Exress 29,95 Euro"
30.00 or 30,00 - "Special dilivery 45,95 Euro"

In column E has only one data from above I mean it could be 5.60 or it could be 5,60 or it could be 8,00 or 8.00

I want output only massages in column H which are against those numbers

Thnks
Vishal
 

Attachments

Last edited:
Hi Vishal - I am little confused...can you just answer a couple of questions

1) How do you decide if this is a simple charge, Standared, DHL Express or Special..

2) Do you mean, 5,60 is for Simple, 14,95 is for Standard, DHL is for 29,95 and Special is 45,95.
 
Asheesh said:
Hi Vishal - I am little confused...can you just answer a couple of questions

1) How do you decide if this is a simple charge, Standared, DHL Express or Special..

2) Do you mean, 5,60 is for Simple, 14,95 is for Standard, DHL is for 29,95 and Special is 45,95.
Click to expand...


Yes exectly

this whole is string "simple charge 5,60 Euro""
 
Hello JAYALAXMI

I have total 6 types charges :
1- 0.00 or 0,00
2- 5,60 or 5.60
3- 8.00 or 8,00
4- 10.95 or 10,95
5- 24.95 or 24,95
6- 30.00 or 30,95
(In german type they are using coma instead of dot, So price could be any format so I mentioed OR)

For first 3 preices (0, 5,60 and 8,00 = "Simple charge 5,60 euro")
For 10,95 "Standard 14,95 Euro"
For 24,95 "DHL Exress 29,95 Euro"
and for 30 "Special dilivery"

That's It
 
Vishal.jagani said:
Hello JAYALAXMI

I have total 6 types charges :
1- 0.00 or 0,00
2- 5,60 or 5.60
3- 8.00 or 8,00
4- 10.95 or 10,95
5- 24.95 or 24,95
6- 30.00 or 30,95
(In german type they are using coma instead of dot, So price could be any format so I mentioed OR)

For first 3 preices (0, 5,60 and 8,00 = "Simple charge 5,60 euro")
For 10,95 "Standard 14,95 Euro"
For 24,95 "DHL Exress 29,95 Euro"
and for 30 "Special dilivery"

That's It
Click to expand...

Hi Vishal,
Can you try this:
=IF(OR(E2=0,E2=5.6,E2=8),"Simple charge 5,60 Euro",IF(E2=10.95,"Standard 14,95 Euro",IF(E2=24.95,"DHL Exress 29,95 Euro","Special dilivery 45,95 Euro")))

Regards,
 
Khalid NGO said:
Hi Vishal,
Can you try this:
=IF(OR(E2=0,E2=5.6,E2=8),"Simple charge 5,60 Euro",IF(E2=10.95,"Standard 14,95 Euro",IF(E2=24.95,"DHL Exress 29,95 Euro","Special dilivery 45,95 Euro")))

Regards,
Click to expand...
please note, your number should not be stored in text values.

If you confirm the logic is correct, then we can move further.

Regards,
 
Vishal.jagani said:
Hello khalid,
Thnks Dear it's working for me

Perfect...
Click to expand...

Thanks Vishal for feedbacks.
here is one more, will cover the strings too:

=IF(OR(E2={5.6,0,8,"5.6","0","8"}),"Simple charge 5,60 Euro",IF(OR(E2={10.95,"10.95"}),"Standard 14,95 Euro",IF(OR(E2={24.95,"24.95"}),"DHL Exress 29,95 Euro","Special dilivery 45,95 Euro")))

You can also amend OR logics for more criteria.
Regards,
 
Hi Khalid,
may I ask about Libre office ?

In this thread I think we don't have allowed I know that

I have really headech regarding this question I couldn't found any solution

Question is very Easy I know but I got confused and I also can't understand web answer

If you really think that I need answer that question then let me know some other way to get solution for this question

I am not asking here because this is Excel Forum and my issue is regarding Libre office so

Thnks
 
Vishal.jagani said:
Hi Khalid,
may I ask about Libre office ?

In this thread I think we don't have allowed I know that

I have really headech regarding this question I couldn't found any solution

Question is very Easy I know but I got confused and I also can't understand web answer

If you really think that I need answer that question then let me know some other way to get solution for this question

I am not asking here because this is Excel Forum and my issue is regarding Libre office so

Thnks
Click to expand...
Hi Vishal,
Sorry, I haven't used Libre office, i have no idea.

Hope someone will update you on this.

Regards,
 
You must log in or register to reply here.
Back
Top