+ Reply to Thread
Results 1 to 3 of 3

Excel 2007 : IF function using OR for statement with two arguments.

  1. #1
    Registered User
    Join Date
    06-22-2012
    Location
    US
    MS-Off Ver
    Excel 2007
    Posts
    2

    IF function using OR for statement with two arguments.

    Hi,

    Can someone help me determine what is wrong with the following statement:

    =IF(Y128>X128,W128)*(OR(Y128=0,0,(W128/X128*Y128)))

    I am trying to create a function that recognizes 2 arguments in one statement/function.

    I want excel to calculate using the following arguments:

    1. If (column Y) is greater than (column X) then result should be (column W) OR
    2. IF (column Y) is = zero then result should be zero, or else divide (column W) by (column X) and multiply by (column Y)

    Thank you

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    16,028

    Re: IF function using OR for statement with two arguments.

    Try:

    =IF(Y128=0, 0, IF(Y128>X128, W128, W128/X128*Y128))
    Never use Merged Cells in Excel

  3. #3
    Registered User
    Join Date
    06-22-2012
    Location
    US
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: IF function using OR for statement with two arguments.

    It worked!
    Thank you so much Zbor and have a great weekend.

+ 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