Hello, please could someone help, I have a cell with =AG10/(1-AH10) in it but I get #Value! when not actually got any data in. AG10 has =IF(S10=1,Q10*R10,"") in it. The AH10 cell is used for a % and it all returns a figure with the % added to it. How could get rid of the #value!?