I need spreadsheet formula help PLEASE!!!

  • Thread starter Thread starter brebrian
  • Start date Start date
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

General ledger spreadsheet 3
If Formula 10
Scrabble Value calculation for Welsh words 0
Conditional Formula Help Please! 4
excel 2003 1
No return for formula 2
IF statement for a column 2
CountIf Formula 1

Back
Top