Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie
Hi all! We have been experiencing an issue on site where threads have been missing the latest postings. The platform host Vanilla are working on this issue. A workaround that has been used by some is to navigate back from 1 to 10+ pages to re-sync the thread and this will then show the latest posts. Thanks, Mike.
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Excel formulas?

  • 04-05-2007 4:04pm
    #1
    dulpit
    Registered Users, Registered Users 2 Posts: 11,409 ✭✭✭✭


    Hey, I'm going through an old excel worksheet at work, need to grab some data from it. Looking at some of the formulas, the guy who put it together uses the $ symbol a lot before cell names. What does this mean?

    e.g.

    $H$16 = E$34 + E$35

    Is this any different to

    H16 = E34 + E35

    Just wondering, in case it does do something important that i'm not aware of...


Comments

  • #2
    py2006
    Registered Users, Registered Users 2 Posts: 9,844 ✭✭✭py2006


    dulpit wrote:
    Hey, I'm going through an old excel worksheet at work, need to grab some data from it. Looking at some of the formulas, the guy who put it together uses the $ symbol a lot before cell names. What does this mean?

    e.g.

    $H$16 = E$34 + E$35

    Is this any different to

    H16 = E34 + E35

    Just wondering, in case it does do something important that i'm not aware of...

    I can't be entirely sure from that formula but normally the dollar sign is used for absolute cell referencing.


  • #3
    EL_Loco
    Registered Users, Registered Users 2 Posts: 901 ✭✭✭EL_Loco


    yes they're very important.

    basically the $ stop the cell reference changing when you cut and paste the equations.

    try this for a good working example.

    (working out a VAT rate of 21%)
    put .21 in cell A1
    in the B column put in random numbers
    in C1 put
    =b1*$A$1

    copy and paste C1 down to say, C20. look at the equations all the way along. Notice the "B1" part changes to reflect the cell it's been pasted into, but the $ references don't change.
    then change the value in A1. Good for setting a cell to be your constant rate or something like that.


  • #4
    dulpit
    Registered Users, Registered Users 2 Posts: 11,409 ✭✭✭✭dulpit


    Cheers for quick replies, nice one... :)


Advertisement