if b7 is 1000 and e7 is 103 what is the persent formula in g7?

hi
not sure exactly what your question is but

=103/1000
format to percent.

regards
FSt1

"utpal" wrote:

if b7 is 1000 and e7 is 103 what is the persent formula in g7?

hi
thx for replying i made exl work sheet & i dont know formula
b7 is $1000 (sales) & e7 $103 (Labor cost) what is persent in g7? (Labor %)

"FSt1" wrote:

hi
not sure exactly what your question is but

=103/1000
format to percent.

regards
FSt1

"utpal" wrote:

if b7 is 1000 and e7 is 103 what is the persent formula in g7?

If Sales includes labor

=E7/B7

If Sales does not include labor

=E7/(B7+E7)


Gord Dibben MS Excel MVP

On Sun, 30 Sep 2007 10:34:01 -0700, utpal
wrote:

hi
thx for replying i made exl work sheet & i dont know formula
b7 is $1000 (sales) & e7 $103 (Labor cost) what is persent in g7? (Labor %)

"FSt1" wrote:

hi
not sure exactly what your question is but

=103/1000
format to percent.

regards
FSt1

"utpal" wrote:

if b7 is 1000 and e7 is 103 what is the persent formula in g7?