Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Very simple - but i need help

  1. #1
    New Member
    Join Date
    Aug 2014
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Very simple - but i need help

    I am trying to get an IF OR function to work. Can I please get the formula from someone ? My head hurts....

    I have a spreadsheet -

    Column B has names in it - Fred, Barney, Wilma, Betty and many others, these names appear in random order down the column. In Column E I need to calculate the earnings. And in Column D is the total units sold. Wilma & Betty earn $100 per unit, every other name earns $50 per unit. I need the formula to calculate the earnings correctly for each name. thanks in advance.

    Name Units Earnings
    Betty 2
    Betty 7
    Betty 4
    Fred 6
    Barney 9
    Wilma 5
    Barney 12
    Fred 3

  2. #2
    Board Regular Norie's Avatar
    Join Date
    Apr 2004
    Location
    Stirling, Scotland
    Posts
    73,724
    Post Thanks / Like
    Mentioned
    24 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Very simple - but i need help

    Try this.

    =D2*IF(OR(B2="Wilma",B2="Betty"),100,50)
    If posting code please use code tags.

  3. #3
    New Member
    Join Date
    Aug 2014
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Very simple - but i need help

    Thank you so much.

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
  •