isconnaugh
New Member
- Joined
- Aug 26, 2015
- Messages
- 2
Hi guys.. Not sure this is possible from the way I've laid this out. But what I'm trying to do is use the =MIN function to find the cheapest period cost but the answer to come up as either 'Option 1', 2, 3 or 4 depending which is cheapest
Here's how I've laid out my data, I'm not sure if I can even get an answer from the way it's been done and I know there's missing data in the 4th table just haven't gotten around to doing it yet![Laugh :LOL: :LOL:](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
Thanks in advance![Smile :) :)](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
Here's how I've laid out my data, I'm not sure if I can even get an answer from the way it's been done and I know there's missing data in the 4th table just haven't gotten around to doing it yet
![11923558_10153067674063015_7661566361318230637_n.jpg](/board/proxy.php?image=https%3A%2F%2Fscontent.fmel1-1.fna.fbcdn.net%2Fhphotos-xap1%2Fv%2Ft1.0-9%2F11923558_10153067674063015_7661566361318230637_n.jpg%3Foh%3D0a083cc969009bc23d45a45f16405d0b%26oe%3D5683806B&hash=77426e38c3e53c4521cf9d9d4c862911)
Thanks in advance
Last edited: