No idea if this is even remotely possible, but here are my 4 if statements. If it is possible and someone could take the time to give me the formula, it would save my brain from a lot of work.
=IF(SUM(B3:B65536)=SUM(Movies!D:D),"☺", "!!")
=IF(SUM(D3:D65536)=SUM(Movies!F:F),"☺", "!!")
=IF(SUM(E3:E65536)=SUM(Movies!G:G),"☺", "!!")
=IF(SUM(G3:G65536)=SUM(Movies!I:I),"☺", "!!")
Here's how to nest if statements
http://www.techonthenet.com/excel/fo.../if_nested.php
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 you have not managed to complete you'r task post a sample workbook. Nesting IF statements is straight forward, and you might even find a better solution to you'r problem.
OK, in the Movie Features tab you'll see 4 cells at the top with !! symbols in them. It is the formulas in those 4 cells that, if possible, I would like to have all in one cell.
Thanks for that. What would you like to sum? are these prices? Could you post an example of the result you would like?
Last edited by Hurricanefly; 06-09-2013 at 10:01 AM.
Do you mean..
=IF(AND(SUM(B3:B65536)=SUM(Movies!D:D),SUM(D3:D65536)=SUM(Movies!F:F),SUM(E3:E65536)=SUM(Movies!G:G),SUM(G3:G65536)=SUM(Movies!I:I)),"☺", "!!")
Life's a spreadsheet, Excel!
Say thanks, Click *
Do you mean..
=IF(AND(SUM(B3:B65536)=SUM(Movies!D:D),SUM(D3:D65536)=SUM(Movies!F:F),SUM(E3:E65536)=SUM(Movies!G:G),SUM(G3:G65536)=SUM(Movies!I:I)),"☺", "!!")
or slightly shorter...
=IF(AND(SUM(B:B)=SUM(Movies!D:D),SUM(D:D)=SUM(Movies!F:F),SUM(E:E)=SUM(Movies!G:G),SUM(G:G)=SUM(Movies!I:I)),"☺", "!!")
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
Thanks For the help, but I guess what I'm trying to see if I can do is get all 4 if statements and their respective results in one cell, not just one overall result.
Hurricane: I just want verification that data from 4 different areas in 2 separate worksheets match up.
Maybe...Originally Posted by cmcasper
=IF(SUM(B3:B65536)=SUM(Movies!D:D),"☺", "!!")&" "&=IF(SUM(D3:D65536)=SUM(Movies!F:F),"☺", "!!")&" "&
=IF(SUM(E3:E65536)=SUM(Movies!G:G),"☺", "!!")&" "&=IF(SUM(G3:G65536)=SUM(Movies!I:I),"☺", "!!")
Guess FDibbins has it with this amendment "•"Formula:
Please Login or Register to view this content.
Last edited by Marcol; 06-09-2013 at 08:57 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks