I'm trying to figure out how to figure out the proper way to right a formula for the below situation
F5 is my day late column. If the day late = 6 a 40 dollar fee is assets and for everyday after the 6th day a 5 dollar fee is added. Attached is my spread sheat.
Thank you for your help
Last edited by blusylver; 01-22-2015 at 03:37 PM.
Please Login or Register to view this content.
If someone has helped you then please add to their Reputation
Substitute the days_late with a cell reference
Formula:
Please Login or Register to view this content.
Please consider adding a * if I helped.
=IF(F6<6,0,40+(F6-6)*5) or
=IF(F6<6,0,40+F6*5-30)
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks