Results 1 to 3 of 3

If / Then help, please!

Threaded View

  1. #1
    Registered User
    Join Date
    02-08-2017
    Location
    DC
    MS-Off Ver
    2013
    Posts
    0

    If / Then help, please!

    I was asked to do the following, and I cant quite figure it out.

    If A1 = (name) then it equals 1, if B1 = (name) then its .5, if C1= (name) then it equals .33. In addition, if B1 = (name) then A1 = .5 or if C1 = (name) then A1 and B1 equal .33.

    Essentially there are three columns of names, some with names others with blanks. Each row of three columns represents ownership of a purchase of a mug. So if two people need to pay for a mug, then A1 and B1 would have a name in it; buy C1 would be blank.

    Looks like this below, and attached:

    Rep Rep 2 Rep 3
    AG
    AG BC
    AG CT
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1