Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Feb 2007
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Formulas (Excel 2003 Professional)

    =IF($K$6>24,IF(L4<=39172,8,0),"")

    Within this formula, I only want the result if another cell contains a specific parameter. How can I get formulate this within this existing formula?

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formulas (Excel 2003 Professional)

    Is this what you want?

    <code>
    IF(AnotherCell="a specific parameter",IF($K$6>24,IF(L4<=39172,8,0),""),"")
    </code>
    Legare Coleman

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •