Prev: Worksheet Change Event log for multiple cells
Next: For-next loop question
From: Rolf on 19 Feb 2010 13:20
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"

From: Rick Rothstein on 19 Feb 2010 13:37
Give this formula a try...

=IF(E1<3.25,"Very Low",IF(E1<6.5,"Medium
Low",IF(E1<7.51,"Neutral",IF(E1<10.77,"Medium High","Very High"))))

--
Rick (MVP - Excel)


"Rolf" <Rolf(a)discussions.microsoft.com> wrote in message
news:C145968F-762B-4D18-8D6C-40ED2F154700(a)microsoft.com...
>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"
>

From: Mike H on 19 Feb 2010 13:38
There's no need to multi post, you have answers in your other 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"
>
 | 
Pages: 1
Prev: Worksheet Change Event log for multiple cells
Next: For-next loop question