Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...
MS Office Forum / Excel / Worksheet Functions / May 2008

Tip: Looking for answers? Try searching our database.

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

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Sue - 31 May 2008 17:27 GMT
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.
Reply to this Message
Fred Smith - 31 May 2008 23:27 GMT
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.

> 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.
Reply to this Message
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage
Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.