| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can the If function be used on blank cells?
I am trying to get the If function to work in this worksheet, but it does
like me... A B C 1 Purch. Paid Bal 2 3 $0.15 -$0.03 4 $73.10 $73.07 5 $29.70 $102.77 6 $102.77 7 $102.77 in the "C" column I would like to have a conditional "IF" A6 is blank and B6 is also blank, then C6 comes up blank, else =C5-A6+B6. that way C7 and below will be blank. Thanks, Bill -- Live simply...Love generously...Care deeply...Speak kindly...Leave the rest to God. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Can the If function be used on blank cells?
One way:
C6: =IF(COUNT(A6:B6)=0,"",C5-A6+B6) In article , "oldsquid" wrote: I am trying to get the If function to work in this worksheet, but it does like me... A B C 1 Purch. Paid Bal 2 3 $0.15 -$0.03 4 $73.10 $73.07 5 $29.70 $102.77 6 $102.77 7 $102.77 in the "C" column I would like to have a conditional "IF" A6 is blank and B6 is also blank, then C6 comes up blank, else =C5-A6+B6. that way C7 and below will be blank. Thanks, Bill |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Can the If function be used on blank cells?
Forgot to say using Excel 2003...
"oldsquid" wrote in message ... I am trying to get the If function to work in this worksheet, but it does like me... A B C 1 Purch. Paid Bal 2 3 $0.15 -$0.03 4 $73.10 $73.07 5 $29.70 $102.77 6 $102.77 7 $102.77 in the "C" column I would like to have a conditional "IF" A6 is blank and B6 is also blank, then C6 comes up blank, else =C5-A6+B6. that way C7 and below will be blank. Thanks, Bill -- Live simply...Love generously...Care deeply...Speak kindly...Leave the rest to God. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Can the If function be used on blank cells?
Thanks! Works like a charm...
"JE McGimpsey" wrote in message ... One way: C6: =IF(COUNT(A6:B6)=0,"",C5-A6+B6) In article , "oldsquid" wrote: I am trying to get the If function to work in this worksheet, but it does like me... A B C 1 Purch. Paid Bal 2 3 $0.15 -$0.03 4 $73.10 $73.07 5 $29.70 $102.77 6 $102.77 7 $102.77 in the "C" column I would like to have a conditional "IF" A6 is blank and B6 is also blank, then C6 comes up blank, else =C5-A6+B6. that way C7 and below will be blank. Thanks, Bill |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUM function doesn't calculate with blank cells | Excel Discussion (Misc queries) | |||
| Count blank cells containing function | Excel Discussion (Misc queries) | |||
| If Function for BLANK cells | Excel Worksheet Functions | |||
| returning blank cells in an IF function | Excel Worksheet Functions | |||
| If function with blank cells | Excel Worksheet Functions | |||
Linear Mode
