Here is another way:

=IF(D3<150,"Limits",VLOOKUP(D3,{150,100;2500,250;6 250,500;12500,"Limits"},2,
TRUE))

--
Regards,
Tom Ogilvy

"Tom Ogilvy" wrote in message
...
Assume the volumn is in in D6


=if(and(D3/1001.5,D3/100<25),"100ml",if(and(D3/2501.5,D3/250<25),"250ml",i
f(And(D3/500<1.5,D3/500<25),"250ml","limits exceeded")))

--
Regards,
Tom Ogilvy

"farsta_online" wrote in message
om...
I need enormous help from you
In my excel workbook I have 3 alternatives for volume (100 ml, 250 ml,
500ml)
The strength = D3/volume and ahs to be between 1,5 and 25 i.e. 1.5 <
D3/volume < 25
What I want trying to do is:
1. take 100 ml. If the condition (1.5 < D3/volume < 25) is true than
set D6 = 100 ml.
2. When False take 250 ml. If the condition (1.5 < D3/volume < 25) is
true than set D6 = 250ml
3. When 2 is False take 500 ml. If the condition (1.5 < D3/volume <
25) is right than set D6 = 500ml
My Q´s are
a) can this be done at al?
b) if yes - how?

Any help we'll be appreciated
With regards
Peter