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

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

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