How to match 3 variable cells

felepen

New Member
Joined
Mar 23, 2013
Messages
2
[FONT=arial, sans-serif]HI,

I am trying to find a way for below problem, any help be highly appreciated.

I have 2 cells for example C2 and D2, Which are dependent on A2, for example Changing A2 will change both C2 and D2.

Question: if i want to achieve C2=80 and D2: 30, then A2 should be 5. given this scenario how can fix C2 and D2 to desired result by predicting what should be in A2 (It can be through a table of possible values, which can be looked up)

Thanks for help


[/FONT][FONT=arial, sans-serif]
[/FONT]
 

Some videos you may like

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

yesterdays

Active Member
Joined
Oct 8, 2014
Messages
337
Please post some sample of your data and what is your goal in that table
 

Watch MrExcel Video

Forum statistics

Threads
1,090,102
Messages
5,412,435
Members
403,427
Latest member
mese0115

This Week's Hot Topics

Top