|
Anthony's VBA Forum Where the knowledge is shared |
|
|
View previous topic :: View next topic |
Author |
Message |
Noexceling
Joined: 31 Dec 2007 Posts: 1
|
Posted: Mon Dec 31, 2007 4:15 pm Post subject: Excel Math formula |
|
|
Trying to create a Math formula that allows for Taking advantage of sale pricing. Any help most appreciated!
In Excel the following:
Qty to Order (G3), Std Package(I3), Price per Unit(J3), Sale Price(K3), = Extended Price(L3)
Example
2case X 40peices per case, 1.00Reg Price, .90Sale Price = 72.00
Not quite sure how to handle the Sale price taking over regular pricing
=IF(SUM(G3*I3)>0,SUM(G3*I3*J3),"") |
|
Back to top |
|
|
|
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
Powered by phpBB © 2001, 2002 phpBB Group
|