If And formular Or somthing else
 

I need Help with a formular !!!!!
C1 6.5
D1 7.5
E1 Actual
F1 I need result

if the Actual = 0.00 - 3.24 I need result verry low
if the Actual = 3.25 - 6.49 I need result medium low
if the Actual = 6.50 - 7.50 I need result Neutral
if the Actual = 7.51 -10.76 I need result medium high
if the Actual = 10.77 - 14.00 I need result verry high

So if i enter in E1 "7" the result i need in F1 "7 Neutral" .
if i enter in E1 "2" teh result i need in F1 " 2 verry low"

If And formular Or somthing else
 

=IF(E1="","",LOOKUP(E1,{0,3.25,6.5,7.51,10.77},{"l ow","medium
low","Neutral","medium high","very high"}))



"Rolf" wrote:

I need Help with a formular !!!!!
C1 6.5
D1 7.5
E1 Actual
F1 I need result

if the Actual = 0.00 - 3.24 I need result verry low
if the Actual = 3.25 - 6.49 I need result medium low
if the Actual = 6.50 - 7.50 I need result Neutral
if the Actual = 7.51 -10.76 I need result medium high
if the Actual = 10.77 - 14.00 I need result verry high

So if i enter in E1 "7" the result i need in F1 "7 Neutral" .
if i enter in E1 "2" teh result i need in F1 " 2 verry low"

If And formular Or somthing else
 

Hmmm,

I see you posted here as well. Repeat there is no need for multi posting.
You may not see it as a problem but those who answer your questions only to
find you already have an answer do see it as one.
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Rolf" wrote:

I need Help with a formular !!!!!
C1 6.5
D1 7.5
E1 Actual
F1 I need result

if the Actual = 0.00 - 3.24 I need result verry low
if the Actual = 3.25 - 6.49 I need result medium low
if the Actual = 6.50 - 7.50 I need result Neutral
if the Actual = 7.51 -10.76 I need result medium high
if the Actual = 10.77 - 14.00 I need result verry high

So if i enter in E1 "7" the result i need in F1 "7 Neutral" .
if i enter in E1 "2" teh result i need in F1 " 2 verry low"