Formula

J

Johnnie

I have created simple sheet in excel.

February March April
Hours Allotted 20.00 20.00 20.00
Hours Billed
Remaining Hours 20.00 20.00 20.00
Carry over from Previous Month 10.00 10.00
Authorized for the month 30.00 30.00
 
V

Vicky

Feb Mar Apr
Hours Allotted 20 20 20
2 Hours Billed 20
3 Remaining Hours =B2-B3 =C2-C3 =D2-D3
5 Carry over from Previous
Mn 2 =IF(B3=0,0,IF(B6<10.01,B6,10)) =IF(C3=0,0,IF(C6<10.01,C6,10))
6 Authorized for the month =B4+B5 =C4+C5 =D4+D5
 

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

Formula Question 3
Look up and Replace 1
Conditional Comment using Cell value as part of it 0
Need subtotals 0
Need subtotals 16
Working hours 5
Importing a space-delimited txt. file right-justified into Excel 2
Item Count vs Item Cost 2

Top