Excel help

Lamp

Gold Star Holder!!
Joined
Jan 16, 2005
Messages
22,673
Using Excel 2002 (yes, I know)....

Here's what I'm trying to do

IF the number in Cell T4 is LESS THAN the number in Cell U1, THEN Cell U4 = the number in cell T4, OTHERWISE Cell U4 = the number in Cell U1

Eg

If T4 = 4, and U1 = 10, then I want U4 to contain 4
If, say, T4 = 100, and U1 = 10, then I want U4 to contain 10

How do you do this in Excel?

I've tried =
Code:
=IF(T4<U1,(U4=T4),(U4=U1))
but all I get is a zero.

Anyone help?

Ta
 

Aoami

I am a FH squatter
FH Subscriber
Joined
Dec 22, 2003
Messages
11,050
don't you need an 'else' in there somewhere. that just looks like you want U4 to equal 2 different integers.
 

pcg79

One of Freddy's beloved
Joined
Dec 22, 2003
Messages
694
IF the number in Cell T4 is LESS THAN the number in Cell U1, THEN Cell U4 = the number in cell T4, OTHERWISE Cell U4 = the number in Cell U1

=if(t4<u1,t4,u1)
put this formula in u4
 

Lamp

Gold Star Holder!!
Joined
Jan 16, 2005
Messages
22,673
You're a star. Thank you very much :love:

Have a cake :D

 

Lamp

Gold Star Holder!!
Joined
Jan 16, 2005
Messages
22,673
IF the number in Cell T4 is LESS THAN the number in Cell U1, THEN Cell U4 = the number in cell T4, OTHERWISE Cell U4 = the number in Cell U1

=if(t4<u1,t4,u1)
put this formula in u4

How would I nest another condition whereby:

IF T4 is zero or a negative number, THEN U4 is zero
ELSE (ie T4 is a positive number) =if(t4<u1,t4,u1)

Cheers
 

dysfunction

I am a FH squatter
Joined
Dec 22, 2003
Messages
9,675
Lamp said:
How would I nest another condition whereby:

IF T4 is a negative number, THEN U4 is zero
ELSE (ie T4 is zero or a positive number) =if(t4<u1,t4,u1)

Cheers
=if (t4<0,0,if(t4<u1,t4,u1))
 

Lamp

Gold Star Holder!!
Joined
Jan 16, 2005
Messages
22,673
Beautiful, thank you very much :D
 

Users who are viewing this thread

Top Bottom