So I have this spreadsheet I am attempting to put together to track data as I input it. In the first table I would put a 1 or a 0 to indicate that I sold either a Unit 1, unit 2, or unit 3 with an interaction which is determined by each row. The table on the top right is supposed to show me the data like total Unit 1, % of Unit 2 compared to the total of Unit 1, and then % of Unit 2 compared to Unit 1.
My problem is that I am having a hard time figuring out how I can have the spreadsheet do the work for me to figure out, If Unit 2 % is less than .6 (60%), than tell me the the closest whole number of additional unit 1's would I need to have = to or greater than .6. The last piece is similar to unit 2 but instead of .6, i need it to be .4.
If you know of better ways to make it easier to input information or to view the data with the perimeters that I set, that would be awesome.
[IMG]114562[/IMG]
Bookmarks