LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 138
Default making cells change relative to each other, cant figure out

One way that you could do this without delving into the depths of VBA
is by using the SOLVER add-in.

For each food relate all other "properties" to it's weight - if cell
B2 is "Chicken Breast" and C2 is "Weight" (= 1oz) then D2 (say) is
Protein (=C2*9). All other properties would need to be similarly
related. All foods would need to be 'Calibrated' against 1 oz.

To increase all values to match Protein =25 run Solver with a Target
Cell of $D$2, To Equal a Value of 25 by Changing Cells $C$2. Because
all other cells are related to C2 when Solver finds the solution for
Protein all of the other values for that food will be updated.

For this to work the Solver add-in must be on your machine and it must
also be enabled - tick the Solver add-in box under <tools<add-ins.

All of this of course could be achieved using VBA but if you just want
a quick and easy solution ....

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
making copied cells change with change in original cell Jennifer Mcdermeit Excel Worksheet Functions 2 July 20th 06 04:58 PM
making cells change relative to each other? cant figure out help plz MMA Excel Discussion (Misc queries) 7 June 14th 06 12:49 AM
making cells change relative to each other? cant figure it out MMA Excel Worksheet Functions 1 June 13th 06 08:09 AM
making cells change relative to each other? MMA Excel Worksheet Functions 0 June 13th 06 05:18 AM


All times are GMT +1. The time now is 03:30 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"