Excel formula

Discount as percentage | #

Calculate discount as a percentage from sale price and discount amount.


Generate Random Integers | #

Use the RANDBETWEEN function to generate random integers.


where bottom is the smallest integer RANDBETWEEN will return and
top is the largest integer RANDBETWEEN will return.

For example, to simulate a six-sided dice.


Holiday Pay | #

Calculate the holiday pay.


0.175 for 17.5% holiday loading
where B3 is 4 weeks normal pay