Hi, I am using Excel 7. I am working on a database to inventory maple syrup.
I use this formula to set the price according to grade. GA, AM, ect.
IF(D22="GA",$N$3,IF(D22="AM",$N$4,IF(D22="DR",$N$5,IF(D22="VD",$N$6,IF(D22="OF",$N$7,"")))))
and then calculate the running cost, weight/barrel *...