=IF(G6=0,"",G6/(G6+H6)*100)


This is to add to figures together and figure the percentage of pass (g6) and fail (h6). When 1 pass and zero fail is entered, the formula works, but when vice versa, the formula does not figure anything but a blank cell (only to be blank when a value wasn't calculated for that particular cell this from this weeks tally....


Help!