Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Conditional SUM
I am trying to work up an estimate for purchasing several items. I have the following data listed within columns: LIST PRICE (in a column of all possible items that might be purchased); DISCOUNT FACTOR (percentage of LIST PRICE for two stores within a cell, for reference to); and, QTY (quatity to purchase). What formula should I use (Excel97) to calculate the following, in English: IF value in QTY is greater than 0, THEN return the product of QTY by DISCOUNT FACTOR by LIST PRICE. |
#2
|
|||
|
|||
=IF(qty0,qty*discount_factor*list_price,0)
-- HTH RP (remove nothere from the email address if mailing direct) "Vince" wrote in message ... I am trying to work up an estimate for purchasing several items. I have the following data listed within columns: LIST PRICE (in a column of all possible items that might be purchased); DISCOUNT FACTOR (percentage of LIST PRICE for two stores within a cell, for reference to); and, QTY (quatity to purchase). What formula should I use (Excel97) to calculate the following, in English: IF value in QTY is greater than 0, THEN return the product of QTY by DISCOUNT FACTOR by LIST PRICE. |
#3
|
|||
|
|||
On Sun, 8 May 2005 01:30:36 +0100, "Bob Phillips"
wrote: =IF(qty0,qty*discount_factor*list_price,0) Yes, it has helped. Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting Error | Excel Worksheet Functions | |||
How do i create a conditional sum? | Excel Worksheet Functions | |||
Effect of Conditional Formatting, Data Validation | Excel Discussion (Misc queries) | |||
Determine cells that drive conditional formatting? | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) |