Results 1 to 17 of 17

change cell formula based on first 2 numbers of another

Threaded View

  1. #1
    Valued Forum Contributor realniceguy5000's Avatar
    Join Date
    03-20-2008
    Location
    Fl
    MS-Off Ver
    Excel 2003 & 2010
    Posts
    951

    change cell formula based on first 2 numbers of another

    Hi,

    Would anyone have a script for something like this?

    I'm looking at range c5:c1200

    Starting at C5

    If the first 2 digits in that number start with 01 then I want the formula to be in G5 = F5*12
    if the first 2 digits are 03 then I want G5 = F5*24
    I have several of these if statement to put in However I need it to check the entire range as well because the formula may be different in each cell (G)?

    Any Idea's to get me started.

    Thank You, Mike
    Last edited by realniceguy5000; 04-21-2009 at 07:16 PM.

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