Very simple - but i need help

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
    Posts
    72,950
    Post Thanks / Like
    Mentioned
    13 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.

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
  •  

 

 
DMCA.com