Help with calculations

M

Michael Writt

I have my company products pricing on an excel spreadsheet. It contains
several items and has 3 brackets. At times I need to deviate from it ,
either by a percentage, say 10% or by an exact amount, say .75/case.
Is there a formula I can plug into this spreadsheet that will calculate
the deviations without me having to manually make the deductions for
each individual item.

Anyone's help would ge greatly appreciated.
 
J

J.E. McGimpsey

Something like this?

A1: =(B1 - C1)*(1-D1)

where

B1: Base price
C1: Any fixed discount
D1: Any % discount.

If C1 and D1 are blank or zero, the formula resolves to =B1.
 
D

doug

-----Original Message-----
I have my company products pricing on an excel spreadsheet. It contains
several items and has 3 brackets. At times I need to deviate from it ,
either by a percentage, say 10% or by an exact amount, say .75/case.
Is there a formula I can plug into this spreadsheet that will calculate
the deviations without me having to manually make the deductions for
each individual item.

Anyone's help would ge greatly appreciated.



------------------------------------------------
[/url]
~~ View and post usenet messages directly from http://www.ExcelForum.com/

.
In general, without using a macro, your cell formulas
Click to expand...
need to have an "IF" statement to test for the various
conditions that precipitate the deviations, if those
conditions do not exceed 7 in number. If those "IF"
conditions are positive, the formula will calculate the
10% or whatever; if the "IF" condition tests negative, the
statement will test for the next condition. That's the
best answer I can give you with the info given.
 
Top