Hi All,

Please see the below formula...when I try to copy it down, I am receiving the #VALUE! error.
Could someone help me with a solution that will hide this?

Thanks!!!

=IF(J16="Split Increase",H16-(I16*0.5),IF(J16="Give Back",G16,IF(J16="Roll Back",G16-(G16*0.05),IF(J16="No Change",H16))))