excel finding the answer to a formula

**Billop16857** · 04-24-2009, 06:55 AM

i've made up this formula and the answer depends on a variable and i was wondering if there is a way that excel can find the smallest answer and what the variable would be

thankss

**zbor** · 04-24-2009, 07:01 AM

Please, upload an example, this is issuficient input...

**Justin Young** · 04-24-2009, 07:02 AM

Can you post an example file? Include an example of the input, the formula and its expected output.

**Billop16857** · 04-24-2009, 08:06 AM

yeah sure sorry bout that i'll upload my work haha
yeah just again i want to know if there is a way excel can find the smallest possbile answer (yellow) depending on what variable a is (blue)

thankss

**Billop16857** · 04-24-2009, 07:19 PM

bumpaaaaaa

**shg** · 04-24-2009, 07:38 PM

Put a number in the cell, and then use Solver to minimize G2 with a constraint to keep B6 >=0 and <=300. Or solve it in closed form by writing the formula for total time, differentiating, and solving for XC.

That's all the help you get on homework.

Please take the time to read the forum rules about thread titles before starting another thread. You've had your one freebie bad title.