James Coats
asked on
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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