Generally it's easier to ignore decimal points and work in pence. Most of the examples here use this convention but it works equally well if you show the decimal points.
The best way to learn is to use the examplesThis is a simple calculator with headings for each person. Numbers under each heading are added.
You can also use */+- and round brackets () like Excel if you need to. Global upliftsSometimes eveyone shares a part of the Bill equally, for instance a bottle of wine or a tip. To apply a global uplift use a # as the first character on a line.# indicates a global uplift that works on all the subsequent sums. For instance if you want to apply a 10% tip to each person you would use: a percentage, e.g. #+10%
or a multiplier, e.g. #*1.1 Or if you want to apply a fixed cover charge per person: use a constant, e.g. #+75
You can have a maximum of four uplifts and they will apply in sequence. Each should be on a separate line and occur before first needed. Generally an uplift would apply to everyone on the bill and thus be at the top but you can also use it further down the bill, where it would apply just to those people underneath.
Uplifts can be confusing when sharing a bottle unequally. In these circumstances it's best just ignore the # operator and add an appropriate amount to each person who shared the bottle.
|