power pivot

Public Schedule Face-to-Face & Virtual Instructor-Led Training - View dates & book

• Home
• Courses
• Promotions
• Schedule
• Formats
• Our Clients

Power Pivot

Resolved · Medium Priority · Version 365

Marialena has attended:
Excel Power Query course

Power Pivot

Hi again,

I have an IF(AND(...)) statement: '= IF(AND(x>'y','y' >1,'z' <2),'y',z1 ) and i've tried to use the SWITH(TRUE()) command since i need more than 2 ifs statements but it doesn't give me the right answer because it doesnt take into account the AND part. How can I write the above command properly?

Thanks
Marialena

RE: Power Pivot

Hello Marialena

I believe what you need to get more than 2 conditions inside an IF function is to use && instead of AND. So your example would look like this:

= IF(x>'y' && 'y'>1 && 'z'<2,'y',z1 )

Please let me know if this solution has worked for you

Kind Regards

Martin

RE: Power Pivot

Hi Martin,

Yeah it works now in simple commands, thanks. However, it gets a bit more complicated when I want to do more calculations. For example:

= IF(MIN(IF(x>1,x,10000),IF(y>1,y,10000),IF(z>1,z,10000))=10000,0,MIN(IF(a>1,a,10000),IF(b>1,b,10000),IF(e>1,e,10000)))

In this case, I get an error with MIN. How would that be solved?

Thanks,
Marialena

RE: Power Pivot

Hi Marialena

As for the more complex formula with the IF and MIN, it might help if you could say in plain English what you want to achieve with the formula

We look forward to hearing from you

Kind Regards

Martin

Will be marked as resolved in 5 days

Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.

Training courses

Training information:

 Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions What does 'Resolved' mean? Any suggestions, questions or comments? Please post in the Improve the forum thread.

Working with 3D formulas

You can only use fill-down if you remove \$ for Absolute References.

View all Excel hints and tips