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
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 🙂

    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Nov 15, 2019

      stpstein 

      If you use Tables better to work with structured references.

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

      stpstein   entirely possible that it's a Table thing. What you did is what I was thinking...and that should copy down the rest of the column too!