Hi Just to circle back I was able to resolve my calculation with some
help from @David Cornwell‚ by inserting the 2 exceptions first that were
contained in my drop down values and then added the PROD calculation. It
ended up much simpler than originally thought. Here was the final
calculation: IF(Estimated Project Value for PM Calculation Updated to
2022 Pricing=0,268,IF(Estimated Project Value for PM Calculation Updated
to 2022 Pricing=1000000,0,PROD(Estimated Project Value for PM
Calculation U...