Results 1 to 2 of 2

Excel 2007 : Formula copy with static value in it

Threaded View

  1. #1
    Registered User
    Join Date
    12-23-2008
    Location
    Algarve, Portugal
    Posts
    1

    Formula copy with static value in it

    Hi,

    I am trying to get the following solved in Excel 2007:

    I have a list with changing values (sheet Taxes) in cell G10 to G200 and two static values in the master value sheet within same book (sheet Values) located in C9 and D9. I want to output the result of the formula to be in cell J10.
    I add the formula in cell J10 like G10*C9-D9 (but using the C9 and D9 from the sheet 'Values') but when I copy the forumula down to J11, it fetches the static values (which are in C9 and D9 in the other sheet) in the following line C10 and D10.

    Want to have the C9 and D9 always static and to have the form just copy the G10 to G200 down but not the static calculation values.

    How to do so?


    ---RESOLVED, switching to static cell through F4 -------

    Thanks
    Last edited by ebmaurer; 12-23-2008 at 11:03 PM. Reason: Resolved

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