| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how do you add-u cells value the othes is based another celll be
I have a Quantity Column. Based on if the Column is 1 or (-1) I do or do not
count the field for my total. if -1 count it with my negatives. if qyuantity is +1 or higher then add the value of row H2:H00 to iu |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how do you add-u cells value the othes is based another celll be
sparkie wrote:
I have a Quantity Column. Based on if the Column is 1 or (-1) I do or do not count the field for my total. if -1 count it with my negatives. if qyuantity is +1 or higher then add the value of row H2:H00 to iu H2:H00? .. to iu? I hope this helps: Assume Quantity in column A; Amount in column B, In C, put: =IF(A2 0, A2 * B2, 0) ----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==---- http://www.newsfeeds.com The #1 Newsgroup Service in the World! 100,000 Newsgroups ---= East/West-Coast Server Farms - Total Privacy via Encryption =--- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| UDF: Celll Row Number | Excel Discussion (Misc queries) | |||
| splitting a celll into half or quadrants | Excel Worksheet Functions | |||
| Celll Address Lookup | Excel Worksheet Functions | |||
| Function Pitfalls in Celll Formatting | Excel Discussion (Misc queries) | |||
| checking celll in column | New Users to Excel | |||
Linear Mode
