| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Formula from one workbook/worksheet to another | Excel Worksheet Functions | |||
| Formula for Excel Worksheet | Excel Worksheet Functions | |||
| If Then Else Formula for Excel Worksheet | Excel Worksheet Functions | |||
| How do I make formula in Excel from other worksheet? | Excel Worksheet Functions | |||
| Formula from VBA to Excel worksheet | Excel Programming | |||
Linear Mode
