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.

Thanks in advance for your help.
Johnnie
 
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
 

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 1
Formula Help 7
Formula selection: a real tough one 11
Conditional lookup 2
INDEX, MATCH, #NA 1
Payment calculation 1
Calculating rates using sumproduct 0
Subtracting military times (decimal format) 2

Top