If And formular Or somthing else

R

Rolf

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"
 
M

Mike H

Rolf,

Maybe this

=E1&LOOKUP(E1,{-0.0009,3.25,6.5,7.51,10.77,14.00001},{" Low"," Med Low","
Neutral"," Med High"," Very High",""})
--
Mike

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

"If And "formular Or somthing else 1
using if and or functions in a formular 2
Calculation if a cell contains a word 4
Can Excel do this? and if so which formula should I use 4
If statement with multiple criteria and multiple results 3
More Fun With If, And, Or? 3
If AND/OR funciton with multiple criteria 2
Combining a OR and a AND in an IF statement 3

Top