Thread: 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.

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.

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.