I am using this formula which is working fine, but I also want the cell to be blank and not show FALSE when the reference cell of E10 is empty.
=IF(E10="A",".26",IF(E10="B",".50",IF(E10="C",".15",IF(E10="D",".32",IF(E10="E",".60",IF(E10="F",".41"))))))
Bookmarks