Microsoft Excel

Discussion in 'Windows - Software discussion' started by i_am_alex, Oct 6, 2007.

Thread Status:
Not open for further replies.
  1. i_am_alex

    i_am_alex Regular member

    Joined:
    Sep 2, 2007
    Messages:
    381
    Likes Received:
    0
    Trophy Points:
    26
    Needing some help in Excel.

    I Fill Down this formula:

    =(H16+I16)*H1+K16-L16

    But I get

    =(H16+I16)*H16+K16-L16

    I think I need an Absolute Cell Reference, but not sure, any help please?

    If I do need an Absolute Cell Reference can someone please tell me how?
     
    i_am_alex, Oct 6, 2007
    #1
  2. i_am_alex

    i_am_alex Regular member

    Joined:
    Sep 2, 2007
    Messages:
    381
    Likes Received:
    0
    Trophy Points:
    26
    Solved

    =(H16+I16)*$H$1+K16-L16
     
    i_am_alex, Oct 6, 2007
    #2
Thread Status:
Not open for further replies.

Share This Page