Re: if then formula

Discussion in 'Microsoft Excel New Users' started by Rich/rerat, Apr 24, 2012.

  1. Rich/rerat

    Rich/rerat Guest

    rich123456

    =IF(SUM($J48:$K48,$M48)*$L48<0,$L48,SUM($J48:$K48,$M48)*$L48)

    "if you want to include 0 to have L48 as your solution then try this":

    =IF(SUM($J48:$K48,$M48)*$L48<=0,$L48,SUM($J48:$K48,$M48)*$L48)

    --
    Rich/rerat
    (RRR News) (message rule)
    ((Previous Text Snipped to Save Bandwidth When Appropriate))


    "rich123456" <> wrote in message
    news:...

    i have a formula in a cell that totals the amounts in that row.

    here is the formula

    =((J48-M48)*L48)+(K48*L48)

    i need help adding this to this formula....

    "if the total is less than 0 then use the number in L48"

    any help here would be greatly appreciated.




    --
    rich123456
     
    Rich/rerat, Apr 24, 2012
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Guest

    HOW DO I USE AN IF FORMULA THEN PUT A VALUE

    Guest, Nov 15, 2005, in forum: Microsoft Excel New Users
    Replies:
    2
    Views:
    165
    RagDyer
    Nov 15, 2005
  2. Guest

    How do I set a formula if A1 is "a" then C1 is 3?

    Guest, Dec 9, 2005, in forum: Microsoft Excel New Users
    Replies:
    5
    Views:
    375
    RagDyeR
    Dec 9, 2005
  3. Guest
    Replies:
    2
    Views:
    247
    Pete_UK
    Feb 21, 2006
  4. Guest

    Is there something like an "If, then" formula?

    Guest, Mar 4, 2006, in forum: Microsoft Excel New Users
    Replies:
    4
    Views:
    162
    Bob Phillips
    Mar 4, 2006
  5. teenbeat

    coloring of cel lower then end time but higher then start time

    teenbeat, Mar 13, 2009, in forum: Microsoft Excel New Users
    Replies:
    2
    Views:
    265
    Shane Devenshire
    Mar 14, 2009
Loading...

Share This Page