if not working

M

Micayla Bergen

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
 
D

DavidC

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
 
M

Micayla Bergen

It was the formatting

Thank you David

DavidC said:
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
Click to expand...
 
Top