Hi all
I need to get a result if W21 in both sheets are more than zero
Can anyone please tell me what needs to be changed in this formula for it to workHTML Code:
Thanks
loopiloo
Hi all
I need to get a result if W21 in both sheets are more than zero
Can anyone please tell me what needs to be changed in this formula for it to workHTML Code:
Thanks
loopiloo
Last edited by FDibbins; 03-13-2013 at 12:09 AM.
Something like
=IF(AND('2011'!W21 > 0,'2012'!W21 > 0),"BOTH","NOT BOTH")
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
=IF(and('2011'!$W21>0,'2012'!$W21>0),'2012'!H21-'2011'!H21,"-")
Try this.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
IF(and('2011'!$W21>0,'2012'!$W21>0),'2012'!H21-'2011'!H21,"-")
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Try it this way maybe:
=IF(AND('2011'!$W21,'2012'!$W21>0),'2012'!H21-'2011'!H21,"-")
The & is not an AND Comparator/Operator, it is basically a shorthand Method of Concatenating 2 text values together
Hope this helps
A picture may be worth a thousand words, BUT, a sample Workbook is worth a thousand screenshots!
-Add a File - click advanced (next to quick post), scroll to manage attachments, click, select add files, click select files, select file, click upload, when file shows up at bottom left, click done (bottom right), click submit
-To mark thread Solved- go top of thread,click Thread Tools,click Mark as Solved
If you received helpful response, please remember to hit the * of that post
Try this:
=IF(MIN('2011'!$W21,'2012'!$W21)>0,'2012'!H21-'2011'!H21,"-")
Quang PT
Five replies within 2 minutes! Too fast to receiving Mod's warning of illegal title!
Thanks for all your replies guys... i used your formula alansidman, it worked fine.
The formula from alansidman worked fine, however i have another problem: some of the numbers in the calculation are negatives
eg: -100 - 100 = 200
Any ideas how i can get 0 with this example?
ps: sorry if i used the wrong title... can i change it?
To change your post title, go to your first post, edit post, change the thread title..(I think that's how it works, been awhile since I've had to do it)
Note- If 2 days or more have passed, PM a forum Moderator to make the change for you ..
I really don't like to be dumb...! but, sorry ive tried and i don't know how to title this to be more relevant...
Last edited by FDibbins; 03-13-2013 at 12:08 AM.
I have changed your title for you
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
So the question now becomes, what if either result =0 ?I need to get a result if W21 in both sheets are more than zero
Posiible solutiion:
Formula:Please Login or Register to view this content.
Hope this helps
Or, maybe, this:
Formula:Please Login or Register to view this content.
After that, I would need to see a sample with some expected results to try anything different...
=IF(and('2011'!$W21>0,'2012'!$W21>0),max(0,'2012'!H21-'2011'!H21),"-")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks