ok so all my formulas are correct but this "#VALUE!" shows in the cells where no data has been selected or inputed.. is there a way to "hide" the error code? its saying theres an error cause there is no data for the formula to calculate.. help anyone?