Display Text and Forumla Result in Cell (excel 2007) - TechRepublic
Question
August 20, 2009 at 06:06 AM
forbes.dan

Display Text and Forumla Result in Cell (excel 2007)

by forbes.dan . Updated 15 years, 9 months ago

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!

This discussion is locked

All Comments