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?

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


Gord Dibben MS Excel MVP

On Tue, 12 Aug 2008 09:48:08 -0700, SuperX
<(E-Mail Removed)> wrote:

>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?

Try this:

A1 = 10%

Enter this formula in B7:

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

--
Biff
Microsoft Excel MVP


"SuperX" <(E-Mail Removed)> wrote in message
news:E2995099-987E-45B2-9F47-(E-Mail Removed)...
> 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?

Short and sweet<g>


Gord


On Tue, 12 Aug 2008 14:05:12 -0400, "T. Valko" <(E-Mail Removed)>
wrote:

>Try this:
>
>A1 = 10%
>
>Enter this formula in B7:
>
>=SUM(B1:B6)*(1-A1)