Hi,
I'm very new at this.
I would like to multiply column 1&2, then multiply that value by column 3 percentage value to give me a discount $$$ amount in column 5. I can get that far! The trouble is in some cases I need to multiply the previous result by an additional percentage amount in column 4, then they All still need to total in column 5???
Is that possible and or how???
Try this formula in column 5, this is how you explained it
Formula:
Please Login or Register to view this content.
This is probably what you mean:-
Formula:Please Login or Register to view this content.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
Really Sorry if I'm not explaining this correctly. These formulas didn't work. Let me explain once more.
H I J K L M
Hours Hour Rate % Discount Extra % Discount Discount Amount Subtotal
10 $100.00 10% 7% #REF!
So in most cases I will only need the discount amount to be 10% which would show $100 in column L and $900 in column M. But in some cases I need to deduct an additional 7% off of the already discounted 10% value, which in the sample above I would need 7% off of the $900. So in this example I want to see $163.00 in column L and $837.00 in Column M.
I hope this is clear and thank you for the help.
Like this?
Row\Col E2: =A2*B2*(1-(1-C2)*(1-D2)) F2: =A2*B2-E2
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks