I have a formula used to figure out commission and I would like it to be blank if the cells that compute this formula are blank. I have figured out how to do it on simple formulas using the =IF(E10=0,"",E10/F10) but how could I do it on this formula =IF(L10<=1.2,"0.50%",IF(L10<=1.5,"1.00%",IF(L10>=1.51,"1.25%",)))
Bookmarks