-=PCTechTalk=- Re: Excel Question (Kinda Long)
- From: Robert Carneal <carnealr@xxxxxxxxxxxx>
- To: pctechtalk@xxxxxxxxxxxxx
- Date: Fri, 05 Sep 2003 10:42:09 -0500
I have started your spreadsheet. Question please.
In you example of:
=IF(D19=2,"Efficient 5851") &IF(D19=3,"Efficient 5351")
&IF(D19=4,"Efficient 5260") &IF(D19=5, "Efficient 5871") &IF(D19=6, "Zyxel
643") &IF(D19=7, "Zyxel 645") &IF(D19=8, "Flowpoint 2200")
&IF(D19=9,"Netopia 7200") &IF(D19=10, "Netopia 7220","")
[End Copy]
Will D19 ONLY have one of those values of 1, 2, 3, 4, 5, 6, 7, 8, 9, 10
ONLY? Always? In my example, if the value is less than 2, it will warn you
and display a message saying: "Minimum Value Too Low" if it is greater than
10, it will display "Maximum value exceeded." I can change that to:
if less than 2, then "Enter a minimum value of 2" if you like. Likewise, I
have any value greater than 10 say: "Enter a value not to exceed 10."
I am just thinking of cases where people enter numbers like .7 (point
seven), -123, and big numbers like 11, 319, etc. I'd like to cover all
possibilities if possible.
What do you think?
Robert
Question pleaseAt 12:01 PM 9/4/2003 -0500, you wrote:
>First of all, if this is not the correct group to ask this question, I
>apologize.
>
>
>I am using Excel 2000 and am having issue trying to pull this particular
>information.
>
>With this work sheet I am trying to accomplish several problems. First of
>all, there are 9 values in cell D19, which displays in text the following
>information, please ignore what is in between the brackets { & }, that was
>added to let me keep up with what the actual values are. All the
>following information is in dropdown boxes where the value of the cells is
>listed in the formula.
>
>
>
>ROUTER TYPES
>
>
>=IF(D19=2,"Efficient 5851") &IF(D19=3,"Efficient 5351")
>&IF(D19=4,"Efficient 5260") &IF(D19=5, "Efficient 5871") &IF(D19=6,
>"Zyxel 643") &IF(D19=7, "Zyxel 645") &IF(D19=8, "Flowpoint 2200")
>&IF(D19=9,"Netopia 7200") &IF(D19=10, "Netopia 7220","")
-Rest of email stripped-
>
>
>Each of the "Router Types" will then need to pull the needed values from
>the following cells, located in 5 different locations, on the
>spreadsheet. Each of these cells has a value between 2 & 8 for the light
>status.
>
>
>
>if(D19)=2 {5851} then pull values from cells (H23), (I23), (J23),
>(K23) Each cell has a value between 2 & 8 {Light Status}
>
>
>
>if(D19)=3 {5351} then pull values from cells (H23), (I23), (J23),
>(K23) Each cell has a value between 2 & 8 {Light Status}
>
>
>
>if(D19)=4 {5260} then pull values from cells (B23), (C23), (E23),
>(F23) Each cell has a value between 2 & 8 {Light Status}
>
>
>
>if(D19)=5 {5871} then pull values from cells (H23), (I23), (J23),
>(K23) Each cell has a value between 2 & 8 {Light Status}
>
>
>
>if(D19)=6 {643} then pull values from cells (H27), (I27), (J27), (L27),
>(N27) Each cell has a value between 2 & 8 {Light Status}
>
>
>
>if(D19)=7 {645} then pull values from cells (H27), (I27), (J27), (L27),
>(N27) Each cell has a value between 2 & 8 {Light Status}
>
>
>
>if(D19)=8 {2200} then pull values from cells (A27), (C27), (D27),
>(E27) Each cell has a value between 2 & 8 {Light Status}
>
>
>
>if(D19)=9 {7200} then pull values from cells (A31), (C31), (D31), (G31),
>(H31) Each cell has a value between 2 & 8 {Light Status}
>
>
>
>if(D19)=10 {7220} then pull values from cells (A31), (C31), (D31), (G31),
>(H31) Each cell has a value between 2 & 8 {Light Status}
>
>I also want to set up some type of warning popup that associates with D19,
>that if the cell value is NOT 1 (reset position) or between 2 & 10, it
>displays the following warning
>
>
>
>
>
>if(D19)=1 ERROR -> MUST ENTER ROUTER TYPE AND LIGHT STATUS<-
>
>
>
>
>
>*********************************************************************************
>
>
>
>LIGHT STATUS
>
>
>
>=IF(D19=2,"OFF","") &IF(D19=3,"Red","") &IF(D19=4,"Flashing Red","")
>&IF(D19=5, "Green","") &IF(D19=6, "Flashing Green","") &IF(D19=7,
>"Amber","") &IF(D19=8, "Flashing Amber","")
>
>
>
>
>
>Please feel free to contact me direct or to the list if you can help me,
>or need further help
>
>
>
>Eddie C.
>
>Kd4bas@xxxxxxxxxxxxxxxxxxx
>
>Remove NO Spam to contact me
>
>
>
>
>
>Eddie Carroll
>KD4BAS / KIN9ET
>First Responder
>Level I Fire Service Instructor
>Morganfield, KY Fire & Rescue
>Incident Page Network KTY-005
>National Incident Notification Network DKY-3
>Storm Chasers of America # 74
>ICQ# 149667298
>http://www.geocities.com/nutcase1967
>In memory of Dale Earnhardt,
>"The Legend Lives on"
>
>To unsub or change your email settings:
>//www.freelists.org/webpage/pctechtalk
>
>To access our Archives:
>http://groups.yahoo.com/group/PCTechTalk/messages/
>//www.freelists.org/archives/pctechtalk/
>
>For more info:
>//www.freelists.org/cgi-bin/list?list_id=pctechtalk
To unsub or change your email settings:
//www.freelists.org/webpage/pctechtalk
To access our Archives:
http://groups.yahoo.com/group/PCTechTalk/messages/
//www.freelists.org/archives/pctechtalk/
For more info:
//www.freelists.org/cgi-bin/list?list_id=pctechtalk
Other related posts:
