May 07 2022 04:46 PM
How do I enter an Item so each time a corresponding $ amount is put into a cell in the same row?
May 07 2022 05:45 PM
In the cell where you want the amount to appear, you enter a formula like
=IF(A1="desired entry",45.67,0)
there are other ways, more sophisticated ways, if you actually have, say, 20 different possible entries for cells in column A, each with its associated dollar amount. Then you could use VLOOKUP and a table with the text entries and the associated dollar amounts.
But you might want to give a more complete description here of what the bigger picture is, so a more robust and reliable answer could be created. What I've given you will work, but depending on the situation, on the importance of it, you want to make sure that there are no "holes" in the logic or design.
May 07 2022 05:56 PM
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.
May 07 2022 06:00 PM
In that case, there are two things you should dig into.
May 07 2022 06:14 PM
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.
May 07 2022 06:29 PM