ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I caluclate a function? (https://www.excelbanter.com/excel-worksheet-functions/7918-how-do-i-caluclate-function.html)

Roelamp

How do I caluclate a function?
 
How do I caluclate Example : C=35% of the total of B as a function?
PLEASE HELP

Dave R.

Do you mean the total of column B?

Try
=.35*SUM(B:B)

or
=.35*B1
if you're looking at only one cell.

"Roelamp" wrote in message
...
How do I caluclate Example : C=35% of the total of B as a function?
PLEASE HELP




Peo Sjoblom

=B1*35%

Regards,

Peo Sjoblom

"Roelamp" wrote:

How do I caluclate Example : C=35% of the total of B as a function?
PLEASE HELP


Frank Kabel

Hi
=B1*0.35

--
Regards
Frank Kabel
Frankfurt, Germany

Roelamp wrote:
How do I caluclate Example : C=35% of the total of B as a
function? PLEASE HELP





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

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