ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   set up absolute for 10% discount, then add in 22% gratuity (https://www.excelbanter.com/excel-worksheet-functions/189540-set-up-absolute-10%25-discount-then-add-22%25-gratuity.html)

Sue

set up absolute for 10% discount, then add in 22% gratuity
 
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.

Fred Smith[_4_]

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.




All times are GMT +1. The time now is 07:49 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com