# Formula Question

J

#### Johnnie

I have created a simple sheet that look like this:

B C
D
February March April
1 Hours Allotted 20.00 20.00 20.00
2 Hours Billed
3 Remaining Hours 20.00 20.00 20.00
5 Carry over from Previous Mn 10.00 10.00
6 Authorized for the month 30.00 30.00

The formula in C5 is =IF(b6<10.01,b6,10). However I do not want to show an
amount in C5 if time has not been billed yet in B2. This applies to D5 from
C2 as well.

Johnnie

G

#### Gary''s Student

=IF(b6="","",IF(b6<10.01,b6,10))

J

#### Johnnie

Gary,
Thanks so much! It works great.
Johnnie

Gary''s Student said:
=IF(b6="","",IF(b6<10.01,b6,10))

V

#### Vicky

Here are the formulas. Sorry it doesnt cut and paste too well. but you
should be able to make out the IF function or copy/paste to Excel

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