Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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" |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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" |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i take somthing off the word processor and put it in a fil | Excel Worksheet Functions | |||
Two Criteria with the COUNTIF function or somthing else? | Excel Worksheet Functions | |||
how do I do a formuls in excel such as (if a1=somthing then b1=a . | Excel Worksheet Functions |