if not working
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
|