set up absolute for 10% discount, then add in 22% gratuity

  • Thread starter Thread starter Sue
  • Start date Start date
S

Sue

need to set up an absolute column 10% discount to a range of cells, times
number of attendees plus absolute of 22% gratuity for a row across. I'm new
at this.
 
What's an "absolute column"?

If your cost is in a1, and the number of attendees is in a2, use the
following:

=a1*0.9*a2*1.22

Regards,
Fred.
 
Back
Top