Can anyone help with a simple way to show a formula result in brackets
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Formula result in brackets
0
Answers
0
Selected Answer
JonP
Assuming the formula result is numeric, you could set a Custom cell format to show negative values within brackets (rather than -42 say). With the cell (or cells) selected, right click, pick Format Cells... then Custom and paste this into the Type: box:
#,##0.00;(#,##0.00)Note that the cell value remains -42 say so can be used in calculations.
If you want to show only negative percentages within brackets, use this Custom format instead:
0.00%;(0.00%)Hope this helps.
Discussion
John, thanks for the answer but the cell is already formatted to be a percentage. Is there a way to format as you show and percentage as well?
For information, the formula is as simple as =C23/C33
For information, the formula is as simple as =C23/C33
JonP (rep: 37) Jan 11, '22 at 10:21 am
JonP- please see revised Answer
John_Ru (rep: 6142) Jan 11, '22 at 10:58 am
Thanks John
JonP (rep: 37) Jan 11, '22 at 11:14 am
Glad it worked for you JonP. Thanks for selecting my Answer.
John_Ru (rep: 6142) Jan 11, '22 at 11:18 am