How is the cell containing the formula formatted? If it is for example
formatted as Number with zero decimals then it will show zero.

--
HTH

Sandy

with @tiscali.co.uk


"Micayla Bergen" wrote in message
...
i have this function
=IF(R5=1,D5,"")
my cell R5 is 1 but i get a 0 instead of 6% which is what D5 is. it is
correct in that it is empty if R5 is empty.

thanks