You're not going to get a divide by zero error from that formula if E20 is
blank, but you will if E22 is blank. Maybe what you want is:

=E20*167/(if(E22=0,1,E22)

"rocky" wrote:

Formula for the following
E20/E22*167
When E20 is empty or not use, howt to write the formula that will ignore E20
and continue wiyh the rest
E20(noy used) and E22 *167 is done.