December 16, 2021
I am not sure if this is the right forum however I am tasked w/building a cost sheet (I have attached a generic sample file) that will calculate the total cost for a specific test (I named them Test 1, 2, 3, etc.)
I can get most of it done however these tests can have a 'difficulty' which impacts how much time is needed to complete the test and ultimately how much a someone has to pay.
There are 2 difficulties, Avg and High, and I want to have the number of hours switched/flipped depending on whether it is Avg or High, I get it so far as that it works w/Avg but when I select High it won't work, I get an error message.
Any help on how to remedy this would be greatly appreciated or if someone has an alternate way of getting this accomplished I am all ears.
December 17, 2021
November 1, 2018