ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   % formula (https://www.excelbanter.com/excel-discussion-misc-queries/181023-%25-formula.html)

Tony7534

% formula
 
I have a cell that contains the % of an hour this has to be mutiplyed by the
number of people attending say a safety talk in another cell at present I sit
and scratch my head for hours if not days trying to work the thing out.
Is there a formula that I can use if any one can help I could send them an
example of the work sheet HELP Intel inside this idiot outside lol

David Biddulph[_2_]

% formula
 
If you have one cell A2, that needs to be multiplied by another cell B2, the
formula is =A2*B2
--
David Biddulph

"Tony7534" wrote in message
...
I have a cell that contains the % of an hour this has to be mutiplyed by
the
number of people attending say a safety talk in another cell at present I
sit
and scratch my head for hours if not days trying to work the thing out.
Is there a formula that I can use if any one can help I could send them an
example of the work sheet HELP Intel inside this idiot outside lol




FSt1

% formula
 
hi
i'm confused.
if i had 25% of an hour and 20 people attended, what would be the expected
results?

regards
FSt1

"Tony7534" wrote:

I have a cell that contains the % of an hour this has to be mutiplyed by the
number of people attending say a safety talk in another cell at present I sit
and scratch my head for hours if not days trying to work the thing out.
Is there a formula that I can use if any one can help I could send them an
example of the work sheet HELP Intel inside this idiot outside lol



All times are GMT +1. The time now is 10:42 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com