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
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Nov 15, 2019

stpstein 

Why don't you use absolute references, e.g.

=$D$2/[@[Allocation %]]

 

stpstein's avatar
stpstein
Copper Contributor
Nov 15, 2019

SergeiBaklan 

 

I don't know why it won't accept anything? I feel like it's such a simple formula.. (screenshot attached)

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

      Nope, won't work for me SergeiBaklan 

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

        stpstein 

        How do you enter the formula? If manually type =$D$2* and when click on the cell in column Allocation % in the same row - it shall work. 

Resources