u/theycallmeLL

ROUNDUP function....

Hi, at the moment the cost of a bet (sports betting) depends on it's price, for example, if 2/1 (or $2.50 in decimel), and I want to win $300 per winning bet, the formula is =300(A1-1)

How can this be modified to automatically round up to the next 10?

For tidyness, I want the cell to be empty if A1 is empty

Many thanks

reddit.com

u/theycallmeLL — 2 days ago

▲ 10 r/nbn

Can't figure out the cabling within my nbn cabinet

Hi, I've just bought a house and can't figure out the cabling as my previous house didn't have a cabinet or setup that looked like this

I get that a cable needs to run from the top box to the bottom, but where does it go? If I connect it to one of the points with the black part, I only get a connection in that corresponding room.

How can I set it up to get each room connected?

Many thanks

u/theycallmeLL — 7 days ago