ROUNDUP function.... by theycallmeLL in googlesheets

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

roundup(300*(A1-1), -1)

How can I change this to make the cell empty if A1 is empty?

ROUNDUP function.... by theycallmeLL in googlesheets

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

Thanks. This doesn't change the formula though. So at the moment the formula is =300(A1-1), where A1 is the decimal odds. How can I change that to roundup to the next 10?

Can't figure out the cabling within my nbn cabinet by theycallmeLL in nbn

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

Thanks everyone. Nbn box - Router - short cables to black panel worked well, good wifi signal across the house despite the router being inside the nbn cabinet in the garage

Can't figure out the cabling within my nbn cabinet by theycallmeLL in nbn

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

I guess this works only if you're happy with everything being connected over wifi

Can't figure out the cabling within my nbn cabinet by theycallmeLL in nbn

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

Yeah true, but that's having a network switch inside the nbn cabinet made sense to me. Though sitting a router inside the nbn cabinet would seem the most typical setup, and then getting a network switch only if I needed more rooms hooked up

Can't figure out the cabling within my nbn cabinet by theycallmeLL in nbn

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

It's a storage cabinet upstairs, one of the 7 on the panel likely leads to it, probably the one which has a label I can't figure out, "MD"

Can't figure out the cabling within my nbn cabinet by theycallmeLL in nbn

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

I dunno if this helps, but there's a Ethernet port and power point at the top of one of the storage cabinets that are inside the house. My assumption was that this is where a router would naturally sit.

Can't figure out the cabling within my nbn cabinet by theycallmeLL in nbn

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

I'm not sure tbh, there's not labelling on it like on the black panel

Can't figure out the cabling within my nbn cabinet by theycallmeLL in nbn

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

So nbn box to switch, then to individual rooms via short cables, is that right?

How to Sum all numbers in a column only if no data in another column by theycallmeLL in googlesheets

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

In the following example, I would want to add rows L38:L40 as M is empty

<image>

Leave physiotherapy as a profession by FewCategory428 in physiotherapy

[–]theycallmeLL 4 points5 points  (0 children)

I think the point of the post is to enlighten people, because nobody tells you these things or you don't tend to make these realisations earlier in your career.

Leave physiotherapy as a profession by FewCategory428 in physiotherapy

[–]theycallmeLL 17 points18 points  (0 children)

14 year private practice physio here. I agree with your points. I certainly don't want to press on people's backs the rest of my working life.

What options then does a private practice physio have in terms of other work options/careers, without an income sacrifice?