Conditional format; if statement

[SuperX]

Is it possible to create a conditional formula that would return a
calculation in another cell?

For example; Cell B1 thru B6 calculate a total. (sum of the column ends up
in B7) I want to be able to incorporate a discount by typing the discount
percentage in cell A1 and have B7 reflect that discount. Is that possible?

 

[Gord Dibben]

=SUM(B1:B6)-(SUM(B1:B6)*A1) where A1 is the discount percentage.


Gord Dibben MS Excel MVP

 

[T. Valko]

Try this:

A1 = 10%

Enter this formula in B7:

=SUM(B1:B6)*(1-A1)

 

[Gord Dibben]

Short and sweet<g>


Gord