ExcelBanter - Formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Formula (https://www.excelbanter.com/excel-discussion-misc-queries/176137-formula.html)

Johnnie[_2_]

Formula

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

vicky

Formula

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

"Johnnie" wrote:

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

All times are GMT +1. The time now is 03:07 AM.