Results 1 to 3 of 3

Thread: Two "IF" functions in the one formula?

  1. #1

    Two "IF" functions in the one formula?



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello,

    Can someone please help me sort this formula out. I'm trying copy a cell value from another page, but I need to have two "IF" functions at once. (Highlighted Red) (does that make sense?)


    =IF('Master Template'!F10="KRE 57",('Master Template'!F24)),or,IF('Master Template'!O10="KRE 57",('Master Template'!O24))

    Thanks in advance for your time.

  2. #2
    Helo use
    =IF('Master Template'!F10="KRE 57",'Master Template'!F24,IF('Master Template'!O10="KRE 57",'Master Template'!O24,""))

  3. #3
    Hey Mr Pike,

    You are a legend, works great Thanks so much for your help

Posting Permissions

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