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