MS Excel 2013 sheet If statements

I am working on the excel sheet excerise and I am have issues with the following:

Column F: "Amount Due"

If the value is less that $100 I need the amount to show instead of the error message.

Column F: "Action"

I've got this almost working. Again here if the amount is less the $100 and it is not "Paid" a blank cell should appear in the "Action" column

Here is what I am trying to do:

Discount (Column E): Use a nested form of the If function to display 15% if Amount is greater than $300., 10% if Amount is greater than $100

Amount Due (Column F): calculate Amount Due (Amount minus the discount of Amount).

Date Due (Column G): calculate Date Due (Inv. Date plus 30 days).

Status (Column I): Use a nested form of the If function to display “Late” if B3 (system date) is greater than Date Due and Paid is not Yes. Otherwise the cell should appear blank (use 2 double quotes for blank “”). An absolute reference will be required in your formula.

Action (Column J): Use a nested form of the If function to display “Collection” if Status is “Late” and Amount Due is greater than $100.00; “Write Off” if Status is “Late” and Amount Due is less than or equal to $100.00. Otherwise the cell should appear blank (use 2 double quotes for blank “”).
146jrc03.xls
James CoatsComputer Info. Sys. StudentAsked:
Who is Participating?
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.

C. Blaise MitsutamaFounder/Principal | Technical Writing | Editing | Training | Design | Presentation | StartupsCommented:
SamuelClemmons,

You were very close. With nested IF statements, sometimes trial and error is the only way to work it out.

I've attached an updated file. Let me know if anything is missing.
146jrc03-rev1.xls
0

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
James CoatsComputer Info. Sys. StudentAuthor Commented:
Dear Ms. Mitsutama,

Thank you very kindly for your assistance in this matter. I am just starting my journey concerning excel sheets. Your help has been quite informative.

Sincerely,

Samuel Clemmons
0
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
Office Productivity

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.