Automatically calculate percentages in a spreadsheet
Posted by Bill Brown on June 27, 2001 6:33 AM
I want to create a spreadsheet with the following fields: invoice amount, category, company a, company b, company c. I then want my user to be able to enter an invoice amount and a catergory, then have the spreadsheet automatically calculate the amounts that companies a, b, and c owe. There will be four different categories, and each company will owe a different percentage depending upon which category is entered by my user. So, for example if the invoice is $5,000, and the category is 1, then A owes 25%, B owes 37%, and C owes 38%. But, if the category is 2, then A owes 50%, B owes 50%, and C doesn't owe anything. Again there will be four categories. Any help you can offer will be greatly appreciated!