ExcelBanter - Formula for excel worksheet

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

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Formula for excel worksheet (https://www.excelbanter.com/excel-programming/375707-formula-excel-worksheet.html)

santaviga

Formula for excel worksheet

Hi all, HELP!!!

I am looking for a formula for a formula for the following.

Total Hours=240

Now I need the cell below this to count 240 + 30% and divide that total by
13, I need this to be returned all in the same cell, Is this possible???

Regards Santaviga

excelent

Formula for excel worksheet

=(240+(240/100*30))/13

If u got 240 in e.g. cell A1 then

=(A1+(A1/100*30))/13

"santaviga" skrev:

Hi all, HELP!!!

I am looking for a formula for a formula for the following.

Total Hours=240

Now I need the cell below this to count 240 + 30% and divide that total by
13, I need this to be returned all in the same cell, Is this possible???

Regards Santaviga

santaviga

Formula for excel worksheet

Hi Excellant, Much appreciated, works great.

Regards

"excelent" wrote:

=(240+(240/100*30))/13

If u got 240 in e.g. cell A1 then

=(A1+(A1/100*30))/13

"santaviga" skrev:

Hi all, HELP!!!

I am looking for a formula for a formula for the following.

Total Hours=240

Now I need the cell below this to count 240 + 30% and divide that total by
13, I need this to be returned all in the same cell, Is this possible???

Regards Santaviga

All times are GMT +1. The time now is 11:14 AM.