I am using excel 2003 and wonder if there is a formula like "if then else"
statement, that I can use in a spreadsheet?
If there is not a formula like this then what else can I use?
Thanks for any help
Chefmike

Example formula entered in B1...............

=IF(A1=0,1000,A1)

If A1 is equal to 0 then return 1000, else return the value of A1


Gord Dibben MS Excel MVP

On Tue, 16 Jan 2007 16:46:01 -0800, chefmike
wrote:

I am using excel 2003 and wonder if there is a formula like "if then else"
statement, that I can use in a spreadsheet?
If there is not a formula like this then what else can I use?
Thanks for any help
Chefmike

I assume that if your referring to IF THEN ELSE you are of an age that used
BASIC some while ago. You're showing your age! I too know IF THEN ELSE!

Seriously, the IF function is the equivalent to IF THEN ELSE. Taking as a
very simple example =IF(a=1,"high","low"), the value in cell A1 =1 it will
return the text "high" (without quotes) and if not it will return the text
"low"The basic (oops). Each of the three elements can be very much more
complicated and include AND and OR (remember those) up to 256 characters -
but you can do more.

If you have a specific problem please post details here and we'll see what
we can do.

Regards.

Bill Ridgeway
Computer Solutions

"chefmike" wrote in message
...
I am using excel 2003 and wonder if there is a formula like "if then else"
statement, that I can use in a spreadsheet?
If there is not a formula like this then what else can I use?
Thanks for any help
Chefmike

Thanks Bill,
Yes I guess I am showing my age and I do remember AND and OR, I will try and
post some more information in a little while. Thanks again

"Bill Ridgeway" wrote:

I assume that if your referring to IF THEN ELSE you are of an age that used
BASIC some while ago. You're showing your age! I too know IF THEN ELSE!

Seriously, the IF function is the equivalent to IF THEN ELSE. Taking as a
very simple example =IF(a=1,"high","low"), the value in cell A1 =1 it will
return the text "high" (without quotes) and if not it will return the text
"low"The basic (oops). Each of the three elements can be very much more
complicated and include AND and OR (remember those) up to 256 characters -
but you can do more.

If you have a specific problem please post details here and we'll see what
we can do.

Regards.

Bill Ridgeway
Computer Solutions

"chefmike" wrote in message
...
I am using excel 2003 and wonder if there is a formula like "if then else"
statement, that I can use in a spreadsheet?
If there is not a formula like this then what else can I use?
Thanks for any help
Chefmike