ExcelBanter - what is the persent formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - what is the persent formula (https://www.excelbanter.com/excel-worksheet-functions/160234-what-persent-formula.html)

utpal

what is the persent formula

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

FSt1

what is the persent formula

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?

utpal

what is the persent formula

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?

Gord Dibben

what is the persent formula

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?

All times are GMT +1. The time now is 01:03 PM.