Hover over image for animation

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

`=C2/B2`

Use the RANDBETWEEN function to generate random integers.

`=RANDBETWEEN(bottom,top)`

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.

`=RANDBETWEEN(1,6)`

Calculate the holiday pay.

`=0.175*B3`

0.175 for 17.5% holiday loading

where `B3`

is 4 weeks normal pay