Percent question

denman_351 · Mar 26th, 2002, 08:50 AM

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 · Mar 26th, 2002, 09:12 AM

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 %

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 26th, 2002, 08:50 AM	#1
denman_351 New Member Join Date: Mar 2002 Posts: 3	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?

Mar 26th, 2002, 09:12 AM	#2
Dave Patton Board Regular Join Date: Feb 2002 Location: Calgary, Alberta Canada Posts: 2,065	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 %