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

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

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

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