If this and that!
Page 2 of 2 FirstFirst 12
Results 11 to 14 of 14

Thread: If this and that!

  1. #11
    New Member
    Join Date
    Apr 2015
    Posts
    29
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: If this and that!

    Nearly there
    =IF(D2="Y",IF(Table6[[#This Row],[Gross £]]>865,753*0.01,IF(AND(Table6[[#This Row],[Gross £]]>113,Table6[[#This Row],[Gross £]]<865),(Table6[[#This Row],[Gross £]]-113)*0.01)),0)
    Sorry for the table references lol

  2. #12
    New Member
    Join Date
    Apr 2015
    Posts
    29
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: If this and that!

    Quote Originally Posted by snjpverma View Post
    Shorter version

    =(D2="y")*IF(E2>865,7.53,IF(E2>113,E2-1.13))
    That works too with the same change.
    Thank you

  3. #13
    New Member
    Join Date
    Apr 2015
    Posts
    29
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: If this and that!

    Thank you both for your replies.
    Very helpful, I was nearly there I had my Y/N conditioning met but could not get the formula to do me sums!

    Thanks again

  4. #14
    Board Regular
    Join Date
    Oct 2008
    Posts
    995
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: If this and that!

    Glad to help

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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