Conditional format; if statement
Try this:
A1 = 10%
Enter this formula in B7:
=SUM(B1:B6)*(1-A1)
--
Biff
Microsoft Excel MVP
"SuperX" wrote in message
...
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?
|