+ Reply to Thread
Results 1 to 4 of 4

If a cell matches another cell then check cell to imediate left and perform basic math....

  1. #1
    Forum Contributor
    Join Date
    02-09-2016
    Location
    West Midlands
    MS-Off Ver
    2016
    Posts
    224

    If a cell matches another cell then check cell to imediate left and perform basic math....

    Hi,

    I have my data as below;

    forum.jpg

    I'm trying to achieve the following.

    If there is a '0' to the left of a Cell in Column U which match's the Value of Cell 'W8' (sorry but its the bottom one 1.83) then return "-100" In the Cell Under FALSE (Cell 'W2').

    If there is a '1' to the left of a Cell in Column U which match's the Value of Cell 'W8' then;

    Times the value In Cell 'W8' (sorry but its the bottom one 1.83) by 100 and then Subtract 100
    and display the Value (which would be "83") In the Cell Under FALSE (Cell 'W2')



    How do i achieve this using VBA?

    Many thanks for looking

  2. #2
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,776

    Re: If a cell matches another cell then check cell to imediate left and perform basic math

    Place this formula in W2 and copy down: =IF(AND(T3=0,U3=$W$8),-100,IF(AND(T3=1,U3=$W$8),$W$8*100-100,""))
    You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
    Practice makes perfect. I'm very far from perfect so I'm still practising.

  3. #3
    Forum Contributor
    Join Date
    02-09-2016
    Location
    West Midlands
    MS-Off Ver
    2016
    Posts
    224

    Re: If a cell matches another cell then check cell to imediate left and perform basic math

    Brilliant, works perfectly!

    Feedback left

  4. #4
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,776

    Re: If a cell matches another cell then check cell to imediate left and perform basic math

    Glad it worked out.

+ 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. [SOLVED] cell a function doing math on previous sheet, cell b - cell c result in cell d...
    By dad812 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-08-2018, 08:20 AM
  2. Replies: 4
    Last Post: 02-19-2017, 03:56 PM
  3. Check if a cell matches string and take value from the adjacent cell
    By iyoossaev in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-18-2016, 07:52 AM
  4. [SOLVED] Basic function help, Subtract LEFT from RIGHT String in single cell :(
    By david gonzalez in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-18-2014, 11:51 AM
  5. Active X Check Box that will perform certain macros based upon cell values
    By houseflipsheet in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-06-2014, 12:31 AM
  6. [SOLVED] How do I check a cell 2 columns to the left of my current cell?
    By jbunk in forum Excel General
    Replies: 3
    Last Post: 06-14-2012, 07:11 PM
  7. right/left click on cell, do some math, show result in pop-up
    By turbosyde in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-11-2010, 10:59 AM

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