Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-18-2015, 06:50 PM
brisbaneguy4109 brisbaneguy4109 is offline How to set this out in Excel or solver Windows 7 64bit How to set this out in Excel or solver Office 2013
Novice
How to set this out in Excel or solver
 
Join Date: Oct 2015
Posts: 2
brisbaneguy4109 is on a distinguished road
Default How to set this out in Excel or solver


A farmer buys 100 animals for $100 .00.The animals include at least one cow, one pig, and one chicken, but no other kind.If a cow costs $10 .00, a pig costs $3 .00, and a chicken costs $0 .50, how many of each did he buy?
Reply With Quote
  #2  
Old 10-18-2015, 08:24 PM
macropod's Avatar
macropod macropod is offline How to set this out in Excel or solver Windows 7 64bit How to set this out in Excel or solver Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,340
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

05 cows
01 pig
94 chickens
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 10-18-2015, 10:37 PM
brisbaneguy4109 brisbaneguy4109 is offline How to set this out in Excel or solver Windows 7 64bit How to set this out in Excel or solver Office 2013
Novice
How to set this out in Excel or solver
 
Join Date: Oct 2015
Posts: 2
brisbaneguy4109 is on a distinguished road
Default

Where can I see the setting out?
Reply With Quote
  #4  
Old 10-18-2015, 11:12 PM
macropod's Avatar
macropod macropod is offline How to set this out in Excel or solver Windows 7 64bit How to set this out in Excel or solver Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,340
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

First, I put 10, 3 and 0.5 in A1-C1, respectively.
Next I put 100 in D2, 1 in B2 and =D2-A2-B2 in C2
Next, I put =A1*A2 in A3 and copied across to C3
Finally, I put =SUM(A3:C3) in D3
Since the goal is to have both C3 & D3 equal to 100, I merely incremented the value in A2 till I got that result. Of course, depending on the final value required, it's also possible B2 would need adjusting as well, but in this case it didn't.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Automatic use of solver on different lines with different parameters Yves Excel Programming 0 02-13-2015 05:25 AM
Help with Solver Problem myusername343 Excel 0 04-10-2014 10:09 AM
Simple Macro help for Excel Solver ue418 Excel Programming 1 06-23-2013 12:34 PM
Question on using solver jcg Excel 0 12-13-2011 05:54 PM
Ms word solver DAREGOT Word 1 03-11-2010 11:52 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:58 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft