Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Question
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Question
=IF(b6="","",IF(b6<10.01,b6,10))
-- Gary''s Student - gsnu200768 "Johnnie" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Question
Gary,
Thanks so much! It works great. Johnnie "Gary''s Student" wrote: =IF(b6="","",IF(b6<10.01,b6,10)) -- Gary''s Student - gsnu200768 "Johnnie" wrote: 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Question
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 "Johnnie" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If Formula question | Excel Worksheet Functions | |||
formula question | Excel Discussion (Misc queries) | |||
Formula Question | Excel Discussion (Misc queries) | |||
Newbie Question - Subtraction Formula Question | Excel Discussion (Misc queries) | |||
formula question | Excel Worksheet Functions |