View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
 
Posts: 2,389
Default set up absolute for 10% discount, then add in 22% gratuity

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.

"Sue" wrote in message
...
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.