| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I need spreadsheet formula help PLEASE!!!
Hello,
I am trying to create an Excel 2003 spreadsheet that will calculate compensatory time. The colums that I have are Earned time (column E) Used time (column F) and Balance (column G). I have tried copying other formulas from simalar worksheets, but I can not get the worksheet to calculate. The formula I tried is =IF(AND(ISBLANK(E5),ISBLANK(F5)),"",G4-E5+F5). Is there another formula I should be using? Here is an example of the sheet I am using: Name Date Explanation Earned Used Balance |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I need spreadsheet formula help PLEASE!!!
Hi
but I can not get the worksheet to calculate If this is the case, check ToolsoptionsCalculation and ensure it is set to Automatic, not Manual. -- Regards Roger Govier "brebrian" wrote in message ... Hello, I am trying to create an Excel 2003 spreadsheet that will calculate compensatory time. The colums that I have are Earned time (column E) Used time (column F) and Balance (column G). I have tried copying other formulas from simalar worksheets, but I can not get the worksheet to calculate. The formula I tried is =IF(AND(ISBLANK(E5),ISBLANK(F5)),"",G4-E5+F5). Is there another formula I should be using? Here is an example of the sheet I am using: Name Date Explanation Earned Used Balance |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I need spreadsheet formula help PLEASE!!!
What do you mean by: "I can not get the worksheet to calculate"?
What result are you seeing from your formula? What is in each of the input cells (E5, F5, & G4)? What result did you expect? -- David Biddulph "brebrian" wrote in message ... Hello, I am trying to create an Excel 2003 spreadsheet that will calculate compensatory time. The colums that I have are Earned time (column E) Used time (column F) and Balance (column G). I have tried copying other formulas from simalar worksheets, but I can not get the worksheet to calculate. The formula I tried is =IF(AND(ISBLANK(E5),ISBLANK(F5)),"",G4-E5+F5). Is there another formula I should be using? Here is an example of the sheet I am using: Name Date Explanation Earned Used Balance |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula to get the spreadsheet address to print on the spreadsheet | Excel Discussion (Misc queries) | |||
| spreadsheet formula | Excel Discussion (Misc queries) | |||
| Is there a way to insert a formula, password or macro in an excel spreadsheet that will automatically delete the spreadsheet? | Excel Discussion (Misc queries) | |||
| Formula Help (new to Spreadsheet) | Excel Worksheet Functions | |||
| How to use same formula throughout the spreadsheet?? | New Users to Excel | |||
Hybrid Mode
