I have a cell that contains a formula that can yield either a dollar value or
a percentage value, depending on inputs. How can I format the cell to
correctly match the result?
I have a cell that contains a formula that can yield either a dollar value or
a percentage value, depending on inputs. How can I format the cell to
correctly match the result?
If the percent is never greater than 100%, then you could custom format the
font color. For example:
[Red][<1]0%;[Blue]$#.00
HTH
Jason
Atlanta, GA
"elad" wrote:
> I have a cell that contains a formula that can yield either a dollar value or
> a percentage value, depending on inputs. How can I format the cell to
> correctly match the result?
Since you didn't state examples, try this custom format, where you'll
*never* have a return of 100%:
[>=1]$#,###.00;[<1]#.0%;General
If you anticipate a return of 100%, try this, where you'll lose the ability
to display $1:
[>1]$#,###.00;[<=1]#.0%;General
--
HTH,
RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
"elad" <[email protected]> wrote in message
news:[email protected]...
I have a cell that contains a formula that can yield either a dollar value
or
a percentage value, depending on inputs. How can I format the cell to
correctly match the result?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks