discount formula in excel The Excel program can be used in a variety of different places to get your work…