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