I need spreadsheet formula help PLEASE!!!

B

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
 
R

Roger Govier

Hi
but I can not get the worksheet to calculate
Click to expand...

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

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?
 
Top