Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    Dec 2012
    Posts
    58
    Thanks
    6
    Thanked 0 Times in 0 Posts

    Formula =[@[Asking price (sale currency)]]/1.58

    All,

    I have come across the baove formula in excel and whilst i think i understand it i cant seem to think why this would be any better the referring to A1 etc.

    A1 is called Asking price (sale currency) so i assume the [@[ ]] acts as a converter for the cell name to the column heading.

    Just wanted to double check i have understood the calculation correctly.

    Thanks in advance.

    Dean

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    The @ is shorthand for 'this row'. The theory is that it is much clearer what the formula is doing using a structured reference than just using A1.
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,827
    Thanks
    136
    Thanked 482 Times in 459 Posts
    Thanks Rory.
    That @Formula looked like something from Lotus to me.

    Dean: I would happily sell my £pounds sterling for $1.58 US dollars. How much do you want?????

    zeddy

  4. #4
    Star Lounger
    Join Date
    Dec 2012
    Posts
    58
    Thanks
    6
    Thanked 0 Times in 0 Posts
    Thanks Rory, thought it was that but wanted to Check.

    Zeddy, as would I, I just got back from the states and got 1.39 to the £ so not good...... budget exchange rates

    Thanks again

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •