Lamp
Gold Star Holder!!
- Joined
- Jan 16, 2005
- Messages
- 22,950
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 =
but all I get is a zero.
Anyone help?
Ta
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