Results 1 to 8 of 8

Thread: IF Formula

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Acolyte Wings's Avatar
    Join Date
    Feb 2015
    Posts
    29
    Articles
    0
    Excel Version
    2013

    IF Formula

    Can someone help?
    I want to be able to return a figure under a salesman's column, but only if their initial's are in a cell, and if there is won under quote status column. I've tried IFs(H349=R349&IF,P349=T357,O349,""), but it doesn't seem to work. Any ideas?

  2. #2
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Posts
    1,663
    Articles
    0
    Excel Version
    O365
    Try

    =IF(AND(H349=R349,P349=T357),O349,"")

  3. #3
    Acolyte Wings's Avatar
    Join Date
    Feb 2015
    Posts
    29
    Articles
    0
    Excel Version
    2013
    Thanks very much, I've been puzzling over that and trying this and that.
    It works

  4. #4
    Acolyte Wings's Avatar
    Join Date
    Feb 2015
    Posts
    29
    Articles
    0
    Excel Version
    2013
    Hello again, how about a formula to return a figure with a % added on as a gp ie 100 would become 125.00 with 20% added as a GP?

  5. #5
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Posts
    1,663
    Articles
    0
    Excel Version
    O365
    Doesn't 100 with 20% added become 120?

    =A"*120%

  6. #6
    Acolyte Wings's Avatar
    Join Date
    Feb 2015
    Posts
    29
    Articles
    0
    Excel Version
    2013
    It does when you add it, but not as a GP. on a calculator I would divide 100 by 0.8 and get 125, which is 20%gp, how can I do that in excel

  7. #7
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Posts
    1,663
    Articles
    0
    Excel Version
    O365
    That would be

    =A2/(1-20%)

Posting Permissions

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