Help with calculations

  • Thread starter Thread starter Michael Writt
  • Start date Start date
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.
 
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.
 
-----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.



------------------------------------------------

~~ 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.
 
Back
Top