Hello, I am creating a refund sheet for work and trying to come up with a formula for the following:
Question: If the student withdrawals within 7 days after their study begins
If Yes: Is the student Domestic, If Yes = Full Fee Refund - $250 or Is Student is International , If Yes = Full Fee Refund - $400
If No: N/A
If anyone could help i would greatly appreciate it.
that can be put together in a Nested IF
just need some cell info
date study begins = A2
date of withdrawal = B2
Student domestic/internation = C2 = any other choice assuming only those two choices in C2
fee paid = D2
=IF ( B2-A2 >7 , N/A , IF( C2 = "domestic", D2-250 , D2-400 ) )
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks