IO:IF statements suck! - U2 Feedback

Go Back   U2 Feedback > Lypton Village > It's Official... > It's Official Archive
Click Here to Login
 
 
Thread Tools Search this Thread Display Modes
 
Old 02-18-2007, 11:23 AM   #1
The Fly
 
wildhoney88565's Avatar
 
Join Date: Nov 2005
Location: wales
Posts: 160
Local Time: 10:21 AM
IO:IF statements suck!

Im trying to do IF statements on microsoft excel....not going well!
If anyone knows how to make it so when a drop down menu displays a certain answer, in a box to the side "A" appears i would b happy!
__________________

wildhoney88565 is offline  
Old 02-18-2007, 01:11 PM   #2
I Serve Larry's Stick
 
clarityat3am's Avatar
 
Join Date: Feb 2001
Location: Rocky Mountains
Posts: 2,996
Local Time: 05:21 AM
I can relate! I had a quiz in my Excel class last week and I could NOT get the IF statements to work, even though in my homework I had no problems with it!

I dunno how to do the other, maybe that's in the homework I'm doing today. lol
__________________

clarityat3am is offline  
Old 02-20-2007, 09:11 PM   #3
Breakdancing Soul Pilgrim
 
UberBeaver's Avatar
 
Join Date: Sep 2005
Location: the most serious...douch hammer ever
Posts: 20,318
Local Time: 05:21 AM
I know how to do it, but...I'm not sure how to explain it really. Send me the file and I can do it.

The if statement should read:
IF(A2="TRUE", "A", "B") or

IF(CELL="condition", "A", "VALUE IF WRONG")

and it would read out like this:

If the CELL TIED TO THE DROP DOWN equals THE CONDITION I SET then set this cell to read "A", otherwise, set this cell to read WHATEVER.

I don't know if that will help or not.
UberBeaver is offline  
Old 02-21-2007, 10:47 AM   #4
Ghost of Love
 
gvox's Avatar
 
Join Date: Dec 2001
Location: In The Ballroom of The Crystal Lights
Posts: 19,879
Local Time: 05:21 AM
did you know that if is the middle word in life?



ducks

__________________
ACROBAT - U2 Tribute on Facebook


http://home.cogeco.ca/~october/images/sheeep.jpg

Don't push this button:
 
I'm serious, don't!


 



gvox is offline  
Old 02-21-2007, 02:10 PM   #5
ONE
love, blood, life
 
JessicaAnn's Avatar
 
Join Date: Sep 2001
Location: Milwaukee, WI (USA)
Posts: 11,743
Local Time: 05:21 AM
ok.
JessicaAnn is offline  
Old 03-05-2007, 10:19 AM   #6
Ghost of Love
 
gvox's Avatar
 
Join Date: Dec 2001
Location: In The Ballroom of The Crystal Lights
Posts: 19,879
Local Time: 05:21 AM
(see Apocalyspe Now)
__________________

__________________
ACROBAT - U2 Tribute on Facebook


http://home.cogeco.ca/~october/images/sheeep.jpg

Don't push this button:
 
I'm serious, don't!


 



gvox is offline  
 

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off



All times are GMT -5. The time now is 05:21 AM.


Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2019, vBulletin Solutions, Inc.
Design, images and all things inclusive copyright © Interference.com
×