Forum Discussion

stpstein's avatar
stpstein
Copper Contributor
Nov 15, 2019

PLEASE HELP! Budget formula won't work

Hi,   I'm trying to create a budget spreadsheet that will have 3 columns: task. % allocated. $ amount. so for example: if the total budget is $100: task 1. 20%. $20 task 2. 50%. $50 etc.   F...
excel
Excel on Mac
Formulas and Functions
mathetes's avatar
mathetes
Gold Contributor
Nov 15, 2019

stpstein   Perhaps this will help. You seem to be using the @ symbol, which I've never used (which may mean I'm not at all qualified to even comment, I realize), but here's what I learn from Google.

  • stpstein's avatar
    stpstein
    Copper Contributor
    Nov 15, 2019

    Hi,

     

    the thing is I'M not putting in the @ sign. I'm simply choosing that row and that's what it generates. I thought it might be because it's in a table (I chose the data and clicked "format as table") but I'm not sure that has anything to do with it. 

    mathetes 

    • mathetes's avatar
      mathetes
      Gold Contributor
      Nov 15, 2019

      is it possible to upload your actual spreadsheet so Sergei and I could look at it rather than screen shots?

       

      By the way, I'm on Excel for Mac, so don't have all the functionality that you might, depending on your system.

      • stpstein's avatar
        stpstein
        Copper Contributor
        Nov 15, 2019

        I just tried it again and rather than clicking on the row I manually put the cell number and that worked (=$D$2*C4) so I guess it's solved. I would love to understand why I couldn't just pick the specific cell, but maybe that has to do with the table formatting?.. mathetes 

         

        and I'm on Mac as well 🙂