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" 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 cellsNext: For-next loop question