Excel 2007. Detailed/Complicated IF(AND) or IF(OR) formulas needed.

I've included a spreadsheet that has some manually entered data on a few rows.  I've included text boxes on the spreadsheet with details concerning my needs for formulas.

I may be trying to get an "IF" statement to do too much.

Please advise.
C--Users-dan-Desktop-Payout_to_Pool.xlsx
baleman2Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

ProfessorJimJamMicrosoft Excel ExpertCommented:
please find attached.

i created two tables  that reside inside named ranges  MyTable1 and MyTable2

then i used the vlookup formula with if function.

the formulas in workbook are self explanatory
C--Users-dan-Desktop-Payout_to_Pool.xlsx

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
baleman2Author Commented:
I understand the formulas in Columns Q and S - now that I see them.

I'm not familiar with VLOOKUP.  I can see on Sheet 3 the information posted there, but I don't know how you've used the "vlookup formula with if function".  Can't find the formulas - are they hidden?

Can you explain?

Everything works!
baleman2Author Commented:
Because I'm unfamiliar with VLOOKUP, I'm now unsure if the data shown in Columns E and G are the result of the VLOOKUP function or not.

On my original spreadsheet (although Columns E and G displayed data) I keyed in the data in those columns manually.

To display the multiplier without keying it in, I thought there would be a formula in E2 as follows:
=IF(C2-A2<15,.010,.005)

The dates shown in A2 and C2 will be pulled in by querying a database and automatically populated.  Then, the formula in E2 would automatically populate the cell with either .010 or .005.  I just couldn't get this same IF statement to also display the phrases I needed in G2.

If the "Paper Sent" date were changed in C2 to 05/20/2016, none of the other fields change.  I would expect C2 multiplier to change to .005, but it doesn't.
HTML5 and CSS3 Fundamentals

Build a website from the ground up by first learning the fundamentals of HTML5 and CSS3, the two popular programming languages used to present content online. HTML deals with fonts, colors, graphics, and hyperlinks, while CSS describes how HTML elements are to be displayed.

baleman2Author Commented:
To make an attempt at further explanation, when this spreadsheet is first opened via querying a database, Columns E and G would be blank.

They would only populate based on the formula placed in Column E as described above.
baleman2Author Commented:
In an attempt at clarification, I've attached another spreadsheet with more notes.

Don't know if this makes it harder or easier.
C--Users-dan-Desktop-Payout_to_Pool.xlsx
baleman2Author Commented:
Wrong attachment.  New one is:  Payout_to_Pool_3
C--Users-dan-Desktop-Payout_to_Pool.xlsx
baleman2Author Commented:
I can't seem to add the new spreadsheet as an attachment.  I'll open a different ticket.
Glenn RayExcel VBA DeveloperCommented:
Please close this question since it appears to have been answered here: 28965511.

I would have recommended the VLOOKUP options as well as they are succinct and more-flexible than long, nested IF statements.

Regards,
-Glenn
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.