Percent question

[denman_351]

This may be a very simple problem but has me stumped. Here is what I want to show: cell A1 shows wins for quotes, cell B1 has loss's for quotes, how do I show percentage of wins cell C1 and have the percent show up for negatives?

 

[Dave Patton]

Wins Losses Win % Loss %

40 20 66.7% 33.3%

Wins in Col C and Losses in Col D

=C3/(C3+D3)

=D3/(C3+D3)

Format the results as %