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.![Smile :) :)](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png)
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.
![Smile :) :)](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png)
Thanks
Angelo
=IF(INT(A1)=A1,"Whole Number",IF(INT(A1)+0.5=A1,"Half Nmber","Other Number"))