Results 1 to 3 of 3

Formula Problems With Cells In Same Coloum

Threaded View

  1. #1
    Forum Contributor
    Join Date
    09-26-2010
    Location
    Australia
    MS-Off Ver
    Excel 2003
    Posts
    182

    Question Formula Problems With Cells In Same Coloum

    Hi

    I'm having problems with getting a formulas to work . I Have attached my worksheet so you can see what problems is im having.


    The problem is the formula in cell L20 is correct =IF(j20="","",J20/L4).
    When I go down to next next cell L21 the formula changes to
    =IF(j21="","",J21/L5). I need the formula as it drops down by 1 cell at a time to always be divided by L4 and continue each time a new line is added

    This is =IF(J21="","",J21/4)
    =IF(J22="","",J22/4)
    =IF(J23="","",J23/4) and so on

    As the quotation grows in rows the formula needs to grow with it

    Hope this makes sense
    Attached Files Attached Files
    Last edited by Mooseman60; 01-24-2011 at 07:42 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