Hi all, I've got the formula for the discount "=SUMPRODUCT(D8:D22,E8:E22)-SUM(F8:F22)", but I do not know how to make that into a negative value ONLY if there is a discount value?
Thank you in advance!
Hi all, I've got the formula for the discount "=SUMPRODUCT(D8:D22,E8:E22)-SUM(F8:F22)", but I do not know how to make that into a negative value ONLY if there is a discount value?
Thank you in advance!
Last edited by rmp123; 02-19-2014 at 05:54 PM.
what is discount value?
Blake 7
If your question has been answered, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
If any member's response has helped to solve your problem, please consider using the scales icon on the top right of their post to show your appreciation.
http://failblog.org/
its dependant on a set of data, I am attaching it
Moderator's note: I have deleted the file, I just noticed it contains sensitive info (email and pp number)
Last edited by FDibbins; 02-19-2014 at 06:15 PM.
i still dont understand what you want. you say you have a formula to work out discount but you want to make it negative if..........
i just want the discount value to be negative (a discount value will only appear if the quantity of an item is 10 or more)
answered here...
http://www.excelforum.com/excel-gene...-discount.html
Not exaxtly a duplicate thread, but close
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Hi Dibbins - hope you are well. I think that his question seems answered!! and by your good self!!
....^....1
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks