Forum Discussion
Item formula
How do I enter an Item so each time a corresponding $ amount is put into a cell in the same row?
5 Replies
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.
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.
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.
