Remain Blank until all information is gathered

**gocolonel77** · 02-20-2013, 09:38 PM

This is my formula in cell C24

=((C23+C16+C9)/12)*52

Cells C16 and C9 have already gathered their information.

Cell C23 is currently showing "0"

I want Cell C24 to remain Blank until C23 has a real number in it

Suggestions

Thanks in advance

**M E Good @ XL4M** · 02-20-2013, 10:00 PM

Try this
C24 =IF(C23<>0,((C23+C16+C9)/12)*52,"")

**benishiryo** · 02-20-2013, 10:02 PM

hi gocolonel77. when you say real number, do you mean above 0? or non-blank? 0 & negatives are real numbers to others. for it all to be above 0, try:
=IF(AND(C9>0,C16>0,C23>0),(C23+C16+C9)/12*52,"")

for it to be non-blank:
=IF(AND(C9<>"",C16<>"",C23<>""),(C23+C16+C9)/12*52,"")

if cells between C9:C23 only consists of these 3 numbers, then consider COUNTIF or COUNTBLANK

i'm assuming you want all 3 cells to be filled. otherwise, the solution above would suffice

**gocolonel77** · 02-20-2013, 11:09 PM

Hey thanks and your questions are valid. I DO need it to include negative numbers. Anything number above and below zero.

Hope this helps

Thanks

Originally Posted by benishiryo

hi gocolonel77. when you say real number, do you mean above 0? or non-blank? 0 & negatives are real numbers to others. for it all to be above 0, try:
=IF(AND(C9>0,C16>0,C23>0),(C23+C16+C9)/12*52,"")

for it to be non-blank:
=IF(AND(C9<>"",C16<>"",C23<>""),(C23+C16+C9)/12*52,"")

if cells between C9:C23 only consists of these 3 numbers, then consider COUNTIF or COUNTBLANK

i'm assuming you want all 3 cells to be filled. otherwise, the solution above would suffice