Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional format; if statement
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional format; if statement
=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 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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional format; if statement
Short and sweet<g
Gord On Tue, 12 Aug 2008 14:05:12 -0400, "T. Valko" wrote: Try this: A1 = 10% Enter this formula in B7: =SUM(B1:B6)*(1-A1) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CONDITIONAL STATEMENT | Excel Worksheet Functions | |||
New Conditional Format Overriding Previous Conditional Format | Excel Discussion (Misc queries) | |||
Conditional format based off of a logical if statement | Excel Discussion (Misc queries) | |||
IF Statement based on Conditional format | Excel Discussion (Misc queries) | |||
Conditional If statement | Excel Worksheet Functions |