Forum Discussion
stpstein
Nov 15, 2019Copper Contributor
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...
stpstein
Nov 15, 2019Copper Contributor
I don't know why it won't accept anything? I feel like it's such a simple formula.. (screenshot attached)
SergeiBaklan
Nov 15, 2019Diamond Contributor
- stpsteinNov 15, 2019Copper Contributor
Nope, won't work for me SergeiBaklan
- SergeiBaklanNov 15, 2019Diamond Contributor
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.
- stpsteinNov 15, 2019Copper Contributor
Sorry, correction. if I simply choose the cell, the formula would be: =$D$2*[@[Allocation
it doesn't have the %]] at the end. if I add it, the error message shows