98.8% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Power Pivot
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
Thank you for your enquiry.
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
Thanks for your response and I'm glad the solution worked.
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 information:
See also:
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
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Working with 3D formulasYou can only use fill-down if you remove $ for Absolute References. |