IF statements-pretty simple?

Toddcan · Apr 17th, 2002, 01:32 PM

I tried to enter the following:
=if(a1
But, no matter what my values in A1 and A3 are, I always get returned value of 1.

In words, I want to do this..
If the value in cell A1 is less than the value in A2, and the value in A2 is less than the value in A3, then return a 5, otherwise, return a 1.

What am I doing wrong?

Toddcan · Apr 17th, 2002, 01:33 PM

sorry.. .html was on

here is my formula..

=if(a1

Mark W. · Apr 17th, 2002, 01:37 PM

Quote:

On 2002-04-17 12:33, Toddcan wrote:
sorry.. .html was on [img]/board/images/smiles/icon_smile.gif[/img]

here is my formula..

=if(a1

"a1
=IF(AND(A1

Tommy Bak · Apr 17th, 2002, 01:38 PM

=if(and(a1

Tommy Bak · Apr 17th, 2002, 01:40 PM

sorry for the strange answer.
=IF(AND(A1

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 17th, 2002, 01:32 PM	#1
Toddcan New Member Join Date: Apr 2002 Posts: 11	I tried to enter the following: =if(a1 But, no matter what my values in A1 and A3 are, I always get returned value of 1. In words, I want to do this.. If the value in cell A1 is less than the value in A2, and the value in A2 is less than the value in A3, then return a 5, otherwise, return a 1. What am I doing wrong?

Apr 17th, 2002, 01:33 PM	#2
Toddcan New Member Join Date: Apr 2002 Posts: 11	sorry.. .html was on here is my formula.. =if(a1

Apr 17th, 2002, 01:38 PM	#4
Tommy Bak Board Regular Join Date: Feb 2002 Location: Guderup, Denmark Posts: 287	=if(and(a1

Apr 17th, 2002, 01:40 PM	#5
Tommy Bak Board Regular Join Date: Feb 2002 Location: Guderup, Denmark Posts: 287	sorry for the strange answer. =IF(AND(A1