I've created an automated Expense report that contains 8 columns where the
user can input the expense amt. to be reimbursed, and off to the side is a
tax calculation section. the sheet works fine, assuming the user only inputs
one expense per row (in any of the 8 columns). however, chances are, they
might enter say 2 or more amts in different columns in the row, which would
still make the correct calculation for the taxes in the row, but NOT in the
column. is there a way I can fix this sheet so that no matter how the
information is inputted, the calculations would be correct? if i only i
could show u what I mean (by a print screen method, perhaps?)