Remember Me?

#1
March 1st 17, 08:02 PM
 Junior Member First recorded activity by ExcelBanter: Apr 2013 Posts: 4
How to handle Brackets [ ]

I have a formula I want to put into Excel and I tried using () instead of brackets and I do not get the correct answer, Below is the equation.

100/[(100-165.03)/113.78]+113.78*62.4 The answer should be 132.78

#2
March 4th 17, 11:51 AM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Aug 2015 Posts: 111
How to handle Brackets [ ]

Milo Bloom wrote:

I have a formula I want to put into Excel and I tried using () instead
of brackets and I do not get the correct answer, Below is the equation.

100/[(100-165.03)/113.78]+113.78*62.4 The answer should be 132.78

Milo,

As far as I can tell, your intended expression looks like this:
1. (100-165.03) = -65.03
2. -65.03/113.78 = -0.5715
3. 100/-0.5715 = -174.98
4. 113.78*62.4 - 7099.9

So it would give the result
5. -174.98 + 7099.9 = 6924.9

Could you break it up into parts again, if necessary with generous
spacing, and using square brackets where that helps clarify the meaning.
By then you may have answered your own question! Replacing the square
brackets with normal bracket in Excel, hopefully you should then get the
result you expect!

If not, come back so that we can take another look.

#3
March 13th 17, 11:11 AM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Aug 2015 Posts: 111
How to handle Brackets [ ]

Terry Pinnell wrote:

Milo Bloom wrote:

I have a formula I want to put into Excel and I tried using () instead
of brackets and I do not get the correct answer, Below is the equation.

100/[(100-165.03)/113.78]+113.78*62.4 The answer should be 132.78

Milo,

As far as I can tell, your intended expression looks like this:
1. (100-165.03) = -65.03
2. -65.03/113.78 = -0.5715
3. 100/-0.5715 = -174.98
4. 113.78*62.4 - 7099.9

So it would give the result
5. -174.98 + 7099.9 = 6924.9

Could you break it up into parts again, if necessary with generous
spacing, and using square brackets where that helps clarify the meaning.
By then you may have answered your own question! Replacing the square
brackets with normal bracket in Excel, hopefully you should then get the
result you expect!

If not, come back so that we can take another look.

Curious to know if you resolved your problem after my reply 9 days ago?
appreciated.

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post cmat Excel Worksheet Functions 2 October 21st 08 10:35 PM Northwoods Excel Discussion (Misc queries) 1 March 2nd 07 04:40 PM tombradshawuk Excel Discussion (Misc queries) 3 November 17th 06 11:19 PM JillM Charts and Charting in Excel 1 July 21st 06 08:03 PM 68magnolia71 Excel Worksheet Functions 1 April 22nd 05 03:44 AM

All times are GMT +1. The time now is 02:57 AM.