Get instant live expert help on I need help with brackets in excel
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
How do add numbers in a column but exclude those in brackets ie 133 (29) + 163 (76) + 13 (74) = Or ideally add the numbers outside the brackets and separately those inside the brackets), therefore total would look like = 309 (179)
Solved by K. F. in 24 mins
I want to sum the numbers from the first sheet of the excel workbook that are in the column D that are between brackets ().
Solved by V. U. in 20 mins
I need a formula to calculate income tax when I have income brackets and different income range
Solved by S. H. in 21 mins
It is an urgent matter so please if anyone can solve this How to set that if the number in the cell is negative to be displayed in brackets no matter how many digits it has? (-1,34) (-3) (-1,6789) 2 6,789. So if the number is positive it is displayed normally but negative in brackets. I tried #,###;(-#,###) but this gives (1,).
Solved by X. H. in 27 mins
Hi i need the custom format for display of numbers in lakhs with two decimals and negative numbers in brackets. for eg -123456789.00 to be displayed as (1,234.57). Can this be provided
Solved by B. S. in 11 mins