Calculate the cost of a Rabies shot for each dog while in the shelter. A rabies shot is considered separate from an immunization shot and costs are calculated separately. Use 1 formula that will work for all the dogs. The rabies shot cost will be new column in your spreadsheet and calculated for each dog. For some dogs this value may be zero