Hi
I just cant get my head around this - some of the cells only require if statements whereas some require if(and statements - what am I doing wrong here?
=if(A2=B2,"No Change",(if(A2>B2,"Value Decrease", if(A2<B2,"Value Increase", if(and(A2=0, B2>0.01,"New", if(and(A2>0.01,B2<0,"No Longer Applicable")))))
Thanks
You have no outcome, regardless on the last and as is, you need to close the brackets after B2<0 and B2>0.01
something like
=IF(A2=B2,"No Change",(IF(A2>B2,"Value Decrease",IF(A2<B2,"Value Increase",IF(AND(A2=0,B2>0.01),"New",IF(AND(A2>0.01,B2<0),"No Longer Applicable"))))))
Hope this helps
Sometimes its best to start at the beginning and learn VBA & Excel.
Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
Available for remote consultancy work PM me
Thanks! But the if statements are taking precedence over the If (and statments even though the criteria are different
Last edited by sophia_1234; 07-09-2014 at 06:28 AM.
Can you send me the data and some examples of what should be there.
Your request is conflicting.
1 rule is...
If(A2>B2,"Value Decrease",
another rule is
IF(A2<B2,"Value Increase",
Yet you also want...
IF(AND(A2=0,B2>0.01),"New",...which would then invoke the IF(A2<B2,"Value Increase", rule
and
IF(AND(A2>0.01,B2<0),"No Longer Applicable" which would trigger the If(A2>B2,"Value Decrease", rule.
I think you need to take another look at what you are trying to do here
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks