|
| Working on improving a spreadsheet for the pigs. Let’s say in column “J” I put in the number of pigs treated, in column “K” I have a drop down list with all the med choices (draxxin/baytril/excede/etc) , then in column “L” is where I pick the dose. Column “M” would be the “cost” which is where I need help figuring out the formula. I could put the cost per ml somewhere for each drug. Just not sure if it would be possible to make a formula so that it would take whatever med I pick in column K and multiply its price times the dose times the number of pigs. Thanks | |
|
Google sheets formula help
