98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Tables
Tables
Resolved · Low Priority · Version 2007
Fri 20 May 2011, 15:39Delegate Sharon said...
Sharon has attended:
Excel Intermediate course
Excel Advanced course
Tables
In the tables we added a bonus column which took the slary and times it by 10%. if you then want some on 20%, when you change one it change them all? How do you solve this?
Thu 26 May 2011, 10:54Trainer Stephen said...
RE: Tables
Hi Sharon
This is a problem you would also get when you copy the formula down in a normal range. Any figure in a formula would be replicated in all the subsequent rows. If you wanted some to receive 20% and some 10% then you would need to use an IF function in place of the straight calculation, and your table would have to contain some information that would indicate which rate would apply in each row
Hope this helps
Regards
Stephen
Wed 1 Jun 2011: Automatically marked as resolved.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
