+ Reply to Thread
Results 1 to 5 of 5

Using @ in excel formulas?

  1. #1
    Registered User
    Join Date
    07-14-2010
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    11

    Using @ in excel formulas?

    I looked online but can't find anything regarding using @ in formulas.

    I was looking at an old spreadsheet from a previous worker and came across these formulas...can someone help with what they are especially the @ symbol?

    =IF([@[Cost Model]]="CPM",[@[Unit Revenue]]*[@[Ordered Units]]*0.001,[@[Ordered Units]]*[@[Unit Revenue]])

    =MAX(IF([@[Cost Model]]="CPM",[@[This Month''s Goal]]*[@[Unit Revenue]]*0.001,[@[This Month''s Goal]]*[@[Unit Revenue]]),0)


    =IF([@[Cost Model]]="CPM",MIN([@[Month''s Units (Adv)]]*[@[Unit Revenue]]*0.001,[@[Revenue Cap]]),MIN([@[Month''s Units (Adv)]]*[@[Unit Revenue]],[@[Revenue Cap]]))

  2. #2
    Valued Forum Contributor
    Join Date
    11-20-2012
    Location
    Seattle, WA USA
    MS-Off Ver
    Excel 2010
    Posts
    597

    Re: Using @ in excel formulas?

    it means it's refering to a single cell in the column and not the whole column which would just be [Cost Mode] the @ indicates that it is in the same row as that the formula is, otherwise it would give you the standard B13 or which ever cell it is see example:example.PNG
    Attached Images Attached Images
    Last edited by scott.s.fower; 06-11-2013 at 08:49 PM.

  3. #3
    Valued Forum Contributor
    Join Date
    11-20-2012
    Location
    Seattle, WA USA
    MS-Off Ver
    Excel 2010
    Posts
    597

    Re: Using @ in excel formulas?

    click the example.PNG that is not in the grey box, they are both the same except that the one in the grey box doesn't show the cells highlighted

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,929

    Re: Using @ in excel formulas?

    Nice explanation Scott, you learn something new every day
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  5. #5
    Registered User
    Join Date
    07-14-2010
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    11

    Re: Using @ in excel formulas?

    Thanks for your help!

+ Reply to Thread

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