Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
How do I write it in excel?
I need to calculate which is more profitable and how to write this in excel?:
If I but corn at 40 and sell it at 100 and it takes two days to grow.
If I but potatos at 30 and sell for 80 and it takes 1 day to grow.
Can I use an excel graph or is there a better way?
1 Answer
- Gary ELv 61 decade agoFavorite Answer
Enter Column Headings starting in Column A, Row 1:
Buy, Sell, Net, Days, Net/Day, Net/$Day, Product
In Cells A2 & A3 enter 40 & 30
in Cells B2 & B3 enter 100 & 80
In Cell C2 enter =B2-A2 and copy that to Cell C3
In Cells D2 & D3 enter 2 & 1
In Cell E2 enter =C2/D2 and copy that to Cell E3
In Cell F2 enter =C2/(A2*D2) and copy that to Cell F3
In Cells G2 & G3 enter Corn & Potatoes
And the answer should be obvious without a chart.
- Anonymous1 decade ago
Open Excel
Press F1.
Have a look there :)
Source(s): Personal Experiences.