+ Reply to Thread
Results 1 to 4 of 4

Different calculations based upon word in cell

  1. #1
    Registered User
    Join Date
    07-15-2015
    Location
    London
    MS-Off Ver
    Office 14
    Posts
    2

    Different calculations based upon word in cell

    Sorry if this question has come up before.

    I want to perform two different calculations based on whether the word Win or Loss is written in an adjacent cell. Not the correct cell numbers but for simplicity, if A1 displays WIN then perform A2*B2, if A1 displays LOSS then i want the cell to just say the value in A2.

    Hope ive been clear.... Thank you.
    Last edited by Mopatop; 07-15-2015 at 05:35 PM.

  2. #2
    Forum Expert gmr4evr1's Avatar
    Join Date
    11-24-2014
    Location
    Texas
    MS-Off Ver
    Office 2010 and 2007
    Posts
    3,448

    Re: Different calculations based upon word in cell

    Try this
    ...
    Please Login or Register  to view this content.
    1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
    You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.

    Tom

  3. #3
    Registered User
    Join Date
    07-15-2015
    Location
    London
    MS-Off Ver
    Office 14
    Posts
    2

    Re: Different calculations based upon word in cell

    Thank you very much.

  4. #4
    Forum Expert gmr4evr1's Avatar
    Join Date
    11-24-2014
    Location
    Texas
    MS-Off Ver
    Office 2010 and 2007
    Posts
    3,448

    Re: Different calculations based upon word in cell

    No problem.

+ 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. Non-Excel... VBA in Word for some calculations?
    By HeyInKy in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-30-2015, 09:44 AM
  2. Replies: 2
    Last Post: 12-02-2014, 06:23 PM
  3. Calculations based off formula from another cell
    By Blackhawks in forum Excel General
    Replies: 14
    Last Post: 07-09-2014, 11:38 AM
  4. Calculations in Word Tables?
    By MKR in forum Word Formatting & General
    Replies: 2
    Last Post: 03-21-2013, 10:39 AM
  5. Replies: 4
    Last Post: 05-01-2012, 03:44 PM
  6. Calculations Based on Cell Format
    By assyrian47 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-15-2007, 03:13 PM
  7. Calculations based on adjacent cell values
    By Jack in forum Excel General
    Replies: 4
    Last Post: 06-10-2006, 09:45 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