IO:IF statements suck!

The friendliest place on the web for anyone that follows U2.
If you have answers, please help by responding to the unanswered posts.

wildhoney88565

The Fly
Joined
Nov 14, 2005
Messages
160
Location
wales
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!
 
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! :mad:

I dunno how to do the other, maybe that's in the homework I'm doing today. lol
 
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.
 
Back
Top Bottom