This has got to be simple math, I've been retired 2 years now and have lost so much of my know how...can you please help.
I am TRYING to create a formula that shows Profit/Loss on selling some items but if I use the formula that I have, it does not show negative... but oh this is going to be hard to explain.
Here is my formula:
=IF(I19-E19>0,I19-E19,"")
If I use just the simple math, I get the VALUE error and cannot total up the Profit Column
If it don't put the blank value in, ALL items show a negative amount because there are no selling prices in most at this point.
Out of 200+ items, there are 3 sold.... one happens to be a $3 negative so THAT negative I need....
See Examples below:
Paid Price (Col E) Selling Price (Col I) Profit (Col J)
$76.51 (blank not yet sold) $(76.51)
$100.99 $175.00 $74.01 Sold Item
$158.49 $155.00 Blank Sold and should read $(3.49) but due to my formula there is no value
My total profit at this time SHOULD show $70.52 however in totaling that column it shows the profit to be $(5.99) because of the first unsold item without yet a dollar value in Column I.
So can you please help me to remember what in the world to do with this.... ya don't use it, ya lose it and this makes me very angry at myself.
Thank you....
ladyck3
aka: Laurie
I am TRYING to create a formula that shows Profit/Loss on selling some items but if I use the formula that I have, it does not show negative... but oh this is going to be hard to explain.
Here is my formula:
=IF(I19-E19>0,I19-E19,"")
If I use just the simple math, I get the VALUE error and cannot total up the Profit Column
If it don't put the blank value in, ALL items show a negative amount because there are no selling prices in most at this point.
Out of 200+ items, there are 3 sold.... one happens to be a $3 negative so THAT negative I need....
See Examples below:
Paid Price (Col E) Selling Price (Col I) Profit (Col J)
$76.51 (blank not yet sold) $(76.51)
$100.99 $175.00 $74.01 Sold Item
$158.49 $155.00 Blank Sold and should read $(3.49) but due to my formula there is no value
My total profit at this time SHOULD show $70.52 however in totaling that column it shows the profit to be $(5.99) because of the first unsold item without yet a dollar value in Column I.
So can you please help me to remember what in the world to do with this.... ya don't use it, ya lose it and this makes me very angry at myself.
Thank you....
ladyck3
aka: Laurie