2 Way Formula - MS Excel

**crrager** · 07-27-2014, 03:50 PM

Hello,

I am trying to find a way to use formulas in an excel workbook that will allow me to enter the data that I have to populate other fields. For example, I may have Cost and Retail and need to calculate Margin. Or, I may have Retail and Margin and need to know the Cost. Essentially I would like to be able to enter data that I have as a "what/if" to calculate several other #s without having to have several different groups of cells to do so. Hopefully this makes sense. Thanks in advance.

Chris

**arlu1201** · 07-27-2014, 03:52 PM

Hello crrager,

Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.

**arlu1201** · 07-27-2014, 03:52 PM

Hello crrager,

Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.

**alansidman** · 07-28-2014, 09:00 AM

This is the Introduction Forum where no questions should be posted. If you start a thread in any of the other sub-forums, I´m sure it will not take long before your request will be solved there.