G
Guest
I don't know if the IF function is what I want, so maybe someone can help me
out.
I have drop-down lists of percentages across the top of my spreadsheet. The
user can select any percentage from 2% to 7%, but 99.9% of the time it will
be either 2%, 4%, or 5%.
Then there is a calculation at the bottom where totals in each column are
multiplied against what ever percentage has been chosen for than column.
I need a formula that will look at my rows of calculations and see if it's
2%, 4%, or 5%. Then I need it to look at the final value (total) and sum up
the total. What I mean is, I need it to sum up the final total for all 2%
values, all 4% values, and all 5% values.
Right now this is what it is (in each column, going across, where the "rate"
and "percentage" are taken from drop down lists above):
Total Time (hours and minutes) X rate (in dollars) = Total Paid X percentage
= Percentage paid
I need a formula to calculate the sums of "percentage paid" for each of 2%,
4% and 5% in a separate cell.
out.
I have drop-down lists of percentages across the top of my spreadsheet. The
user can select any percentage from 2% to 7%, but 99.9% of the time it will
be either 2%, 4%, or 5%.
Then there is a calculation at the bottom where totals in each column are
multiplied against what ever percentage has been chosen for than column.
I need a formula that will look at my rows of calculations and see if it's
2%, 4%, or 5%. Then I need it to look at the final value (total) and sum up
the total. What I mean is, I need it to sum up the final total for all 2%
values, all 4% values, and all 5% values.
Right now this is what it is (in each column, going across, where the "rate"
and "percentage" are taken from drop down lists above):
Total Time (hours and minutes) X rate (in dollars) = Total Paid X percentage
= Percentage paid
I need a formula to calculate the sums of "percentage paid" for each of 2%,
4% and 5% in a separate cell.