Re: Creating multiple IF lines - complicated problem -

Tech-Archive recommends: Fix windows errors by optimizing your registry

Thanks for feeding back. Your flowchart only showed 3 sets of
variables, but at least you seem to have grasped how the method works.

Pete

lokideviluk wrote:
Hi guys,

I've tried your method Pete_uk and it seems to working perfectly, I
need to add in the other figures but its just a case of duplication.

I apologise about the 100 thing, it should be 1000

The varibles are

Times by Range Minimum
0.36 <750 217.8
0.32 751-1000 275.2
0.3 1001-1500 332.65
0.28 1501-2000 455.5
0.27 2001-3000 564.99
0.25 3001-4000 788.77
0.23 4001> 961.98

Regards
Ryan


--
lokideviluk
------------------------------------------------------------------------
lokideviluk's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=36249
View this thread: http://www.excelforum.com/showthread.php?threadid=560445

.

Quantcast