Results 1 to 8 of 8

When dragging a formula, how to make it go opposite direction?

Threaded View

  1. #1
    Registered User
    Join Date
    03-07-2014
    Location
    640932326656
    MS-Off Ver
    excel 2010
    Posts
    20

    When dragging a formula, how to make it go opposite direction?

    Hi Guys,

    I need to have my formula move opposite direction.
    For example, if in Cell A2, I have "=A1*2", and normally, if I drag the cell down, Cell A3 will have "=A2*2", but that's not what I need. I need it to be B2*2 (So the formula refers vertical not horizontal).

    Is there a way to do that?

    Thank you!
    Jolene

    PS. Sorry about the typo for the title... didn't realize it till I post it
    Last edited by zbor; 03-17-2014 at 03:31 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Draw in same X-axis but two Y-axis in opposite direction in a same graph
    By shawpnik in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-11-2014, 10:13 PM
  2. Odd problam - keys move the opposite direction
    By sprites in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-24-2013, 10:51 AM
  3. Replies: 1
    Last Post: 03-11-2013, 05:09 PM
  4. OPPOSITE FORMULA
    By roy.okinawa in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-21-2005, 11:25 PM
  5. How do I make a 3 d graph using depth in Ft., a N-S direction in .
    By psmx401 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-07-2005, 04:10 PM

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