It was the formatting

Thank you David

"DavidC" wrote:

Hi Micaykla,

First I would check the formating of cell D5. If it is set to show no
decimal places and not percentage then it is likely that 6% (.oo6) will show
as 0. Check to make sure that the format in cell D5 is set to 0.00%.

Hope this helps

regards

DavidC

"Micayla Bergen" wrote:

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