open All Channels
seplocked Out of Pod Experience
blankseplocked Need simple formula in excel
 
This thread is older than 90 days and has been locked due to inactivity.


 
Author Topic

Black Sabbath
Posted - 2010.12.09 13:36:00 - [1]
 

Hi,

looking a simple formula excel.

I bought 1000 units of one item for 23.00
The next day I bought 2000 items for 22.95

I want to sell those items with profit and need to know
for how much I have to sell it at least.
How do I calculate the middle value of both in excel?

Thanks

VanNostrum
Posted - 2010.12.09 13:53:00 - [2]
 

Edited by: VanNostrum on 09/12/2010 13:54:20
errr...that's very easy

Please visit your user settings to re-enable images.


obviously that 'lowest you should sell' is the number that evens out your expense and income
anything higher than that value is profit

Black Sabbath
Posted - 2010.12.09 14:10:00 - [3]
 

Edited by: Black Sabbath on 09/12/2010 14:46:22
oh I just enabled images, thanks for info. Its right =)

Caleidascope
Minmatar
Republic Military School
Posted - 2010.12.09 20:11:00 - [4]
 

Don't forget the sales tax.


 

This thread is older than 90 days and has been locked due to inactivity.


 


The new forums are live

Please adjust your bookmarks to https://forums.eveonline.com

These forums are archived and read-only