Forum Discussion
dinothekiwi
May 07, 2022Copper Contributor
Item formula
How do I enter an Item so each time a corresponding $ amount is put into a cell in the same row?
dinothekiwi
May 08, 2022Copper Contributor
That's very helpful, much appreciated.
I often make tables to track my Building jobs. There are some Items that have fixed prices/costs and although the Item is quick to enter it's time consuming also having to input the amount each time.
mathetes
May 08, 2022Gold Contributor
Here: I've created a simple example. The image is here; the file is attached below. You fill in the yellow backed cells, the rest is done for you.
- dinothekiwiMay 08, 2022Copper ContributorThat's really cool. It's testing my Excel limits though.
I will need to study it more if I want to replicate.
Thanks again.