PDA

View Full Version : Solved: IF THEN COMMAND



Tenspeed39355
08-18-2008, 05:43 AM
Good morning guys A friend of mine ask me if I used the
IF THEN command. I have never used that command so can you send me
the formula for the command?
Here is an example of what I would use it in.
if C3>B3 the result would be A3.
Another example.
if C3>B3 the result would be Over or Under
I have tried to find the formula but no luck.
Max

NukedWhale
08-18-2008, 10:17 AM
Let's assume you want a value of zero returned when C3 is not greater than B3

IF(C3>B3,A3,0)

Bob Phillips
08-18-2008, 10:57 AM
Don't mean to be rude, but I see that you have over 200 posts and you are telling me that you have never used IF?

mdmackillop
08-18-2008, 01:34 PM
Hi Tenspeed,
I notice that the last 4 threads you started are "unsolved" with no final response from yourself. I would expect you to repond to posts if you wish further assistance here.
Regards
MD

Cyberdude
08-18-2008, 02:45 PM
I would like to elaborate on NukedWhale's response. There is no IF THEN command . . . it's just an IF command, so if you were looking for something with a "THEN" in it, you won't find it.
The general format is something like:
IF( condition , "TRUE" command , "FALSE" command )
The "TRUE command (and "FALSE" command) are actually expressions that can each be very complex in themselves. The "TRUE" command is the "THEN" part of an IF THEN logic. The "FALSE" command is the "ELSE" part of an IF THEN logic, and is optional if not needed.
For each "IF(" string there must be a matching ")" somewhere in the command, usually at the end.
I strongly recommend that you go to the Excel HELP file for more exhaustive information and examples.

Tenspeed39355
08-18-2008, 06:25 PM
Hi guys First let me say that to my knoledge I have sent a rating of each
thread and sent in a note closing the thread. If this is not the case then
let me know where to go to close the threads.
Thanks for your reply on the IF THEN COMMAND
I will close this thread and give a rating.
Max

Aussiebear
08-19-2008, 04:18 AM
Tenspeed39355, above your initiial post you will see the Thread tools options, Click Thread Tools, select Mark Thread Solved, then click Perform Action.

Tenspeed39355
08-19-2008, 04:45 AM
Good morning. There is one problem with going to the initiial post.
I have no idea where they are. How about directing me to them so I can take
care of closing the threads.
Max

Aussiebear
08-19-2008, 04:58 AM
Somehow I think you've found it..... right?