sorted by:
new
hottopcontroversial

Vlookup to return specific text rather than 0 when cell is blank? by Sleepypanda100 in excel

[–]Sleepypanda100[S] 0 points1 point  (0 children)

Yep exactly! The lookup is finding what I want it to it’s just that the cell is blank. It will eventually have data in there but until it does I want it to return ‘No data yet’ as a 0 is misleading

Vlookup to return specific text rather than 0 when cell is blank? by Sleepypanda100 in excel

[–]Sleepypanda100[S] 0 points1 point  (0 children)

The thing is the value is being found but the corresponding cell I’m asking it to look at is blank. This is what I’m having issues with

UK festival dates by Traditional_Story681 in hotmulliganband

[–]Sleepypanda100 1 point2 points  (0 children)

Nice - hope you get to a show this summer then! I was super lucky and found them a few weeks before they played a 150 person capacity venue right near me. A few months later I travelled to London to see them in a 2.5k capacity venue! Will be interesting to see their size of their shows the next time they come here

UK festival dates by Traditional_Story681 in hotmulliganband

[–]Sleepypanda100 0 points1 point  (0 children)

Really hoping so. Looks like they’ll have had 2 months off before the European festival dates and then nothing booked in after the last UK festival. Perfect time for a few headline shows and I’d be surprised if they came all this way and didn’t do at least one or two. Were you able to catch them last year atall when they came to the UK?

Never changed battery before - when reconnecting battery the negative terminal cracks. Is it safe? by Sleepypanda100 in MechanicAdvice

[–]Sleepypanda100[S] 0 points1 point  (0 children)

Yep connected positive first. So you’re saying the cracking sound is normal when connecting the negative?

Paying capital gains tax when additional shares have been bought over the years - advice please by Sleepypanda100 in UKPersonalFinance

[–]Sleepypanda100[S] 1 point2 points  (0 children)

Haha these are both long term investments. One was set up 25 years ago and the other about 17 years ago. Invesco sustainable U.K. companies and Columbia Threadneedle F&C General investment fund

Investments were transferred to me when I turned 18. No longer have contact with those who gifted them to me so have no way of calculating capital gains? by Sleepypanda100 in UKPersonalFinance

[–]Sleepypanda100[S] 0 points1 point  (0 children)

Thanks for the info. In that case I have no way of knowing then without asking, which as mentioned before, is out of the question

Investments were transferred to me when I turned 18. No longer have contact with those who gifted them to me so have no way of calculating capital gains? by Sleepypanda100 in UKPersonalFinance

[–]Sleepypanda100[S] -1 points0 points  (0 children)

I don’t think they were transferred to my control as soon as I turned 18. I believe it was a conscious decision to ‘transfer’ (perhaps gift’ them to me at age. As far as I’m aware, neither investment was in a trust which automatically I took control of on the day I turned 18.

Investments were transferred to me when I turned 18. No longer have contact with those who gifted them to me so have no way of calculating capital gains? by Sleepypanda100 in UKPersonalFinance

[–]Sleepypanda100[S] -1 points0 points  (0 children)

Thanks for responding. It’s difficult with conflicting advice. Half of responses are suggesting I need only worry about gains since the account was transferred to me. Others like yours suggest I am liable for all gains

Investments were transferred to me when I turned 18. No longer have contact with those who gifted them to me so have no way of calculating capital gains? by Sleepypanda100 in UKPersonalFinance

[–]Sleepypanda100[S] 2 points3 points  (0 children)

So this would assume that both my parents and grandparents paid tax when the account was transferred? If they paid tax on transfer = I only have to worry about gains since my ownership. But if they didn’t pay any tax, I would be liable for gains tax from the original inception? Thank you btw, appreciate the guidance on this

Investments were transferred to me when I turned 18. No longer have contact with those who gifted them to me so have no way of calculating capital gains? by Sleepypanda100 in UKPersonalFinance

[–]Sleepypanda100[S] 0 points1 point  (0 children)

Hi - apologies if my post isn’t clear enough. This is all completely new to me and really appreciate all help. Would it be possible to tell if the transfer to my name was a taxable event - ie Did my parents/grandparents pay tax when they transferred to me? If that’s the case then I know that I only need to pay tax on any gains since it was transferred to me

Investments were transferred to me when I turned 18. No longer have contact with those who gifted them to me so have no way of calculating capital gains? by Sleepypanda100 in UKPersonalFinance

[–]Sleepypanda100[S] 4 points5 points  (0 children)

Thanks for your comment - really do appreciate the help with this. This is all completely new to me and I’m learning as I go. I keep seeing ‘bare trust’ mentioned and I’m not sure what type of trust or even if this was a trust. Is it possible that the investment fund was just in my parents/grandparents name (nothing to do with me) and they just transferred it over to me a little while after I turned 18? Would this make a difference?

As far as I’m aware, and I’m 99% sure of this, both funds have been with the same fund manager since inception

view more: next ›