Hello
I pinched this really nifty formula for identiying round sums in a cell but now need to tweak it so it returns a blank if the cell it is looking at contains nothing. Be very grateful for you help.
Thanks
Angelo
=IF(INT(A1)=A1,"Whole Number",IF(INT(A1)+0.5=A1,"Half Nmber","Other Number"))
I pinched this really nifty formula for identiying round sums in a cell but now need to tweak it so it returns a blank if the cell it is looking at contains nothing. Be very grateful for you help.
Thanks
Angelo
=IF(INT(A1)=A1,"Whole Number",IF(INT(A1)+0.5=A1,"Half Nmber","Other Number"))