Hi,
I'm trying to calculate the discount price a Sales Exec can offer to clients and I'm finding it really hard!
My spreadsheet is here - http://imgur.com/a/ZjSqm
The top left hand table is working as a Vlookup to calculate the Rate Card price and that's working fine.
What I need to calculate is the Discount Price. This would be (Rate Card Price * No. Of Job Boards) - % in bottom right table.
Can anybody help with this?
Thanks
Bookmarks