I was wondering what I would need to do to make this formula return the accurate number?
At the moment, I have a formula that is not actually doing what I need it to do. Basically what I have is an inventory sheet and when folks remove from the inventory I need it to look at the cost of that item from the cost column in that specific row and return a total $ Amt Used. However, occasionally, the item is returned and needs to be returned to inventory (which should just zero out the amount on that row. In addition, when we add to the inventory we need to indicate zero for the amount used in that row. When an assessment is purchased, we use a column [Ordered/ Received] and will insert a new row when placing the item into inventory for that particular assessment, but when it is being returned we just add the number back into the row. So I am a bit stumped on this one at the moment can anyone help me? Here is the current formula which is not returning a correct number and I have already tried place a minus sign in front of the bracket before [Ordered/ Received] and I have also changed the number in that row to a negative number, nothing is working. Here is the current formula
=([Number of Assessments Requested]4 * Cost4) - ([Ordered/ Received]4)
Here is a screenshot of part of the sheet.