Excell

[Kcalehc]

I've been working on a spreadsheet for smithing that allows me to price items and have the stats to hand when people ask. I put in the costs for the base components and it works out the price of each item for me, and the (approx) sucess rate (based on formulas found here). With that it shows the minimum price to sell at to break even over time and a few other handy things (like you can tell it if you have a geerlock or not and it reworks everything from that).

Anyway, its mostly for my own personal use for the time being, the main problem I am having is with the 'supposed' min and max (5% and 95%) success rates.

Does anyone know of a way to limit the maximum/minimum values in a cell? I cant seem to make it do this so currently some success rates are 100%+ or -ve in places. Which of course throws the whole thing out...

any ideas?

(and dont say use a different spreadsheet, I have a hard enough time with excell as it is!)

Thanks in advance.

[Heartsong_Steelsoul]

Hmm, I would make an if statement (or two nested ones, actually).

If(*formula* > 95%, 95, if(formula<5, 5, formula))

basically

[eqNichola]

Excel has spreadsheet functions MIN() and MAX() which do what they sound like, so

=MIN(0.95, <formula>)

and

=MAX(0.05, <formula>)

will do what you want. The only slightly 'huh?' part is that you use MAX to set a minimum value and MIN to set a maximum value

To have both limits applied at once, do

=MIN(0.95, MAX(0.05, <success rate formula>))

[Lilosh]

With advice like this, I think I shall soon Excell at Excel.

-Lilosh

[Morani]

With Access to the people here, a Word or two of encouragement and maybe a few PowerPoints you should get a good picture of it. Just keep a positive Outlook.

(Ok, so the Photo Editor thing was a stretch..)

[Lilosh]

I'm to busy groaning to move beyond the FrontPage of this thread.

-Lilosh

[Woodeckt]

Oh come on Lilosh you cannot open the shades and see the Windows in front of you?

[Galathnor]

Gee. Can a guy even get a WORD in here. ))

[Kcalehc]

Thanks for the help, I'll give them a try.