# Excel help

Discussion in 'The Front Room' started by Lamp, Jul 8, 2012.

1. 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

2. ### AoamiI am a FH squatter

don't you need an 'else' in there somewhere. that just looks like you want U4 to equal 2 different integers.

3. ### pcg79One of Freddy's beloved

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

• Like x 1
4. You're a star. Thank you very much Have a cake  5. 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

6. =if (t4<0,0,if(t4<u1,t4,u1))

• Like x 1
7. Beautiful, thank you very much Replies:
1
Views:
197

Replies:
7
Views:
410

Replies:
3
Views:
459

Replies:
9
Views:
462

Replies:
1
Views:
238