Maths/Excel help pls

Welcome, Guest. Please login or register.
April 28, 2024, 01:17:21 PM

Order through Amazon and help blonde Poker

2272618 Posts in 66755 Topics by 16946 Members
Latest Member: KobeTaylor

blonde poker forum

Community Forums

The Lounge

Maths/Excel help pls

0 Members and 1 Guest are viewing this topic.

« previous next »

Pages: [1]

Author

Topic: Maths/Excel help pls (Read 1193 times)

outragous76

Hero Member

Offline

Posts: 13363

Yeah Bitch! ......... MAGNETS! owwwh!

Maths/Excel help pls

« on: April 07, 2011, 08:23:48 PM »

I am needing to show % savings in excel

as an example

claim 100

settled at 70

if I use (= 70/100*100) - it gives me the reduction of the total as an answer ie 70%

I want it to show the saving ie30% - can anyone come up with a formula please

tyty


	Logged

".....and then I spent 2 hours talking with Stu which blew my mind.........."

rossfourfive

Hero Member

Offline

Posts: 1135

Re: Maths/Excel help pls

« Reply #1 on: April 07, 2011, 08:26:17 PM »

=1-(70/100)


	Logged

kinboshi

ROMANES EUNT DOMUS
Administrator
Hero Member

Offline

Posts: 44302

We go again.

Re: Maths/Excel help pls

« Reply #2 on: April 07, 2011, 08:27:07 PM »

100-

or 1-


	Logged

'The meme for blind faith secures its own perpetuation by the simple unconscious expedient of discouraging rational inquiry.'

outragous76

Hero Member

Offline

Posts: 13363

Yeah Bitch! ......... MAGNETS! owwwh!

Re: Maths/Excel help pls

« Reply #3 on: April 07, 2011, 08:35:46 PM »

ty both - knew there would be a quick solution


	Logged

".....and then I spent 2 hours talking with Stu which blew my mind.........."

skolsuper

Hero Member

Offline

Posts: 1510

Re: Maths/Excel help pls

« Reply #4 on: April 07, 2011, 09:13:32 PM »

Wow.


	Logged

outragous76

Hero Member

Offline

Posts: 13363

Yeah Bitch! ......... MAGNETS! owwwh!

Re: Maths/Excel help pls

« Reply #5 on: April 07, 2011, 09:31:57 PM »

Quote from: skolsuper on April 07, 2011, 09:13:32 PM

Wow.

If there is horizontal cracking running through brickwork, what do you believe the problem to be?

Does it make a difference between cavity brickwork and traditional brickwork?

What remedies would you propose?


	Logged

".....and then I spent 2 hours talking with Stu which blew my mind.........."

rossfourfive

Hero Member

Offline

Posts: 1135

Re: Maths/Excel help pls

« Reply #6 on: April 07, 2011, 09:37:52 PM »

Quote from: outragous76 on April 07, 2011, 09:31:57 PM

Quote from: skolsuper on April 07, 2011, 09:13:32 PM

Wow.

Good answer


	Logged

thetank

Hero Member

Offline

Posts: 19284

Re: Maths/Excel help pls

« Reply #7 on: April 07, 2011, 10:26:41 PM »

Quote from: rossfourfive on April 07, 2011, 09:37:52 PM

Quote from: outragous76 on April 07, 2011, 09:31:57 PM

Quote from: skolsuper on April 07, 2011, 09:13:32 PM

Wow.

Good answer

totally

Though I now need closure on wtf we're going to do about these bricks.


	Logged

For super fun to exist, well defined parameters must exist for the super fun to exist within.

outragous76

Hero Member

Offline

Posts: 13363

Yeah Bitch! ......... MAGNETS! owwwh!

Re: Maths/Excel help pls

« Reply #8 on: April 07, 2011, 10:58:10 PM »

haha tank - just for you

horizontal cracking is a sign of wall tie failure in cavity brickwork (usually down to the use of ferrous ties and not the more modern stainless steel). The ties corrode and fail meaning that the two "skins" of brickwork move independently and do not provide adequate lateral support causing horizontal cracking (rather than vertical cracking as would be seen in subsidence for example).

Traditional remedies include cutting out sections of brickwork at say 600mm centres and inserting new ties. This is expensive and time consuming. A more modern approach includes the insertion of long steel rods through the mortar joints which are in turn tied back to the inner leaf but at less frequent centres (i dont do resi so cant tell you too much of this system).

Hope that helps you sleep!