![]() |
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. |
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