I'm trying to calculate a formula that is the option of a percentage off a percentage. My numbers are:
Item price: $500
Vendor Discount: 20%
Client Discount: 20%
Output should read (500*20%)=400 THEN (400*20%)=320

Is this possible to do all in 1 formula or do I need to just put in separate cells and hide? Also, will it be a problem in the calculation if there is no vendor discount?

Thank you so much. I've been trying to figure this out for too long.