software

i have this function
=IF(R5=1,D5,quot;quot;)
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

quot;Micayla Bergenquot; wrote:

gt; i have this function
gt; =IF(R5=1,D5,quot;quot;)
gt; my cell R5 is 1 but i get a 0 instead of 6% which is what D5 is. it is
gt; correct in that it is empty if R5 is empty.
gt;
gt; 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.ukquot;Micayla Bergenquot; gt; wrote in message
...
gt;i have this function
gt; =IF(R5=1,D5,quot;quot;)
gt; my cell R5 is 1 but i get a 0 instead of 6% which is what D5 is. it is
gt; correct in that it is empty if R5 is empty.
gt;
gt; thanks
It was the formatting

Thank you David

quot;DavidCquot; wrote:

gt; Hi Micaykla,
gt;
gt; First I would check the formating of cell D5. If it is set to show no
gt; decimal places and not percentage then it is likely that 6% (.oo6) will show
gt; as 0. Check to make sure that the format in cell D5 is set to 0.00%.
gt;
gt; Hope this helps
gt;
gt; regards
gt;
gt; DavidC
gt;
gt; quot;Micayla Bergenquot; wrote:
gt;
gt; gt; i have this function
gt; gt; =IF(R5=1,D5,quot;quot;)
gt; gt; my cell R5 is 1 but i get a 0 instead of 6% which is what D5 is. it is
gt; gt; correct in that it is empty if R5 is empty.
gt; gt;
gt; gt; thanks