+ Reply to Thread
Results 1 to 3 of 3

Evaluate to columns; compare two columns and return result

  1. #1
    Registered User
    Join Date
    07-20-2011
    Location
    Kerala, India
    MS-Off Ver
    Excel 2013
    Posts
    81

    Thumbs up Evaluate to columns; compare two columns and return result

    Hi! Good afternoon

    Thanks for all your support!

    I use MS Office 2007

    I have 2 columns : Amount and Rate

    Amount RATE DESIRED
    556583.53 NA NA
    541388.85 NA NA
    563172.72 NA NA
    470147.84 0.32 150447.3088
    557689.88 0.19 105961.0772
    368929.92 0.32 118057.5744
    669637.41 0.32 214283.9712
    316508.91 0.32 101282.8512
    318117.64 0.52 165421.1728
    424263.52 NA NA
    366445.48 NA NA
    497342 NA NA
    470445.58 0.19 89384.6602
    379561.09 NA NA

    I need column "C" to check whether B is 'NA' if true return 'NA'
    ELSE calculate: a*B

    I tried with a folmula :

    =IF(C2="NA","NA","=A2*B2")

    First part is ok : it is returning "NA"
    but it does not multiply A*B if NA not found

    Appreciate your early reply
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    03-28-2014
    Location
    Hyderabad,India
    MS-Off Ver
    Excel 2013
    Posts
    1,833

    Re: Evaluate to columns; compare two columns and return result

    Hi try this
    =IF(B2="NA","NA",A2*B2)
    Punnam

  3. #3
    Forum Expert boopathiraja's Avatar
    Join Date
    07-12-2013
    Location
    Coimbatore,TamilNadu, India
    MS-Off Ver
    Excel 2007, 2013, 2016, 365
    Posts
    1,455

    Re: Evaluate to columns; compare two columns and return result

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Click just below left if it helps, Booşathì

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Compare two columns and result in the third.
    By Marlize in forum Excel General
    Replies: 7
    Last Post: 04-30-2014, 02:03 PM
  2. [SOLVED] IF formula, to evaluate two columns to return a new value
    By masond3 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-05-2013, 02:08 AM
  3. [SOLVED] Compare 2 columns with another 2 columns as return value from 3rd column
    By DHFE in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-04-2013, 07:54 AM
  4. Compare Values in Multiple Columns and return a result
    By edbhome in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-18-2009, 09:37 AM
  5. compare two columns, then calculate a result
    By dazp1970 in forum Excel General
    Replies: 9
    Last Post: 12-11-2005, 09:45 AM

Tags for this Thread

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