Results 1 to 4 of 4

Equation based on one cell with word & number

Threaded View

dagindi Equation based on one cell... 02-09-2011, 01:32 PM
NBVC Re: Equation based on one... 02-09-2011, 01:34 PM
dagindi Re: Equation based on one... 02-09-2011, 05:02 PM
NBVC Re: Equation based on one... 02-09-2011, 05:12 PM
  1. #1
    Forum Contributor dagindi's Avatar
    Join Date
    06-02-2008
    Location
    New York, NY
    MS-Off Ver
    Excel 2007 & 2010
    Posts
    295

    Equation based on one cell with word & number

    Is it possible for Excel to run an equation based on a cell that contains a word and a number. For example:
    A1 = $100,000
    A2 = Bob 15
    A3 = James 8
    A4 = Michelle 18

    Can excel identify the number and multiply by $100,000??
    Last edited by NBVC; 02-10-2011 at 08:51 AM.

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