I need spreadsheet formula help PLEASE!!!

[brebrian]

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

 

[Roger Govier]

Hi

but I can not get the worksheet to calculate

If this is the case, check Tools>options>Calculation> and ensure it is set
to Automatic, not Manual.

 

[David Biddulph]

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?