+ Reply to Thread
Results 1 to 3 of 3

SImple formula question for you guys

  1. #1
    Registered User
    Join Date
    11-20-2003
    Posts
    18

    SImple formula question for you guys

    I'm not sure how to use the "OR" function. I want to do the following:

    IF A1 or A2 = "x" then B1*B2, if not then C1*C2


    Do you guys have an answer. It's always easier than I think


    Phoenix

  2. #2
    Forum Expert
    Join Date
    06-18-2004
    Location
    Canada
    MS-Off Ver
    Office 2016
    Posts
    1,474
    Try...

    =IF(OR(A1="x",A2="x"),B1*B2,C1*C2)

    Hope this helps!

  3. #3
    Registered User
    Join Date
    11-20-2003
    Posts
    18
    Looks good Thanx


    Phoenix

+ Reply to Thread

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