I have a formula to display text and a formula result in one cell as follows:
=”BALANCE (“&MIN(B3:WU3)&”)”
The MIN range shows me the lowest daily balance in a range of numbers. The problem is that I can’t get the MIN formula result to diplay only 2 decimals. Instead it is showing a long string:
BALANCE (297.972908347958)
I want it to show:
BALANCE (297.97)
I have changed the formating on the cell to variety of different things (number, accounting, currenty, text, etc) with no change.
Any suggestions would be appreciated!