Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Create a formula in Excel?
I am working with a book inventory in excel. In rows 1 thru 10 column D, I
record the quantity of a book purchased under seperate invoices. In rows 12 thru 20 Column D, I record the quantity of that book sold to seperate parties. I want to create a formula in column E of row 1 that will subtract the total of column D rows 12 thru 20 from column D row 1 without a negative number so that it will post the overage into column D row 2. Example: D1 = 4, the sum of D12:D20 =5, E1 should equal D1 and E2=1. Please offer some sugestions. Thank you. |
#2
|
|||
|
|||
I am not sure I understand what yopu mean but perhaps this will work in E2
=ABS(SUM(D12:D20)-D1) in E1 =D1 Regards, Peo Sjoblom "Fuzzy Odie" wrote: I am working with a book inventory in excel. In rows 1 thru 10 column D, I record the quantity of a book purchased under seperate invoices. In rows 12 thru 20 Column D, I record the quantity of that book sold to seperate parties. I want to create a formula in column E of row 1 that will subtract the total of column D rows 12 thru 20 from column D row 1 without a negative number so that it will post the overage into column D row 2. Example: D1 = 4, the sum of D12:D20 =5, E1 should equal D1 and E2=1. Please offer some sugestions. Thank you. |
#3
|
|||
|
|||
This helped for the two cells that I refered to however, I need to have
(example) D1 = 4, the sum of D12:D20 =5, E1 should equal D1 and E2=1 or if the sum of D12:D20 < 4 record the lower number as in 3 or 2. If there is a way to show you a sample spread sheet to help let me know. Thanks for the info. "Peo Sjoblom" wrote: I am not sure I understand what yopu mean but perhaps this will work in E2 =ABS(SUM(D12:D20)-D1) in E1 =D1 Regards, Peo Sjoblom "Fuzzy Odie" wrote: I am working with a book inventory in excel. In rows 1 thru 10 column D, I record the quantity of a book purchased under seperate invoices. In rows 12 thru 20 Column D, I record the quantity of that book sold to seperate parties. I want to create a formula in column E of row 1 that will subtract the total of column D rows 12 thru 20 from column D row 1 without a negative number so that it will post the overage into column D row 2. Example: D1 = 4, the sum of D12:D20 =5, E1 should equal D1 and E2=1. Please offer some sugestions. Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
How to create a formula in Excel | Excel Worksheet Functions | |||
How do I create a formula in Excel that will countif or sumif bef. | Excel Worksheet Functions | |||
How do I create a multi formula IF function in Excel? | Excel Worksheet Functions | |||
how do i create a blank cell in excel using a formula | Excel Worksheet Functions |