Excel help

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

  1. Lamp

    Lamp I am a FH squatter

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

    Aoami I 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. pcg79

    pcg79 One 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 Like x 1
  4. Lamp

    Lamp I am a FH squatter

    You're a star. Thank you very much :love:

    Have a cake :D

    [​IMG]
     
  5. Lamp

    Lamp I am a FH squatter


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

    dysfunction FH is my second home

    =if (t4<0,0,if(t4<u1,t4,u1))
     
    • Like Like x 1
  7. Lamp

    Lamp I am a FH squatter

    Beautiful, thank you very much :D
     

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.