ISBLANK
 

I have a range of Cells:
A6:A17
The even numbered cells will always have some text in them.
The odd numbered cells may or may not have any values.
IF(ISBLANK("ALL ODD NUMBERED CELLS IN RANGE"),BLANK,(SOME CALCULATION IF
FALSE)

How would the syntax in ""'s in the above formula look?

Thanks in advance,
Aaron Neunz

In Cell B6 Type

=IF(ISODD(ROW(A6)),IF(ISBLANK(A6),"","Whatever"))
And copy it down through B6:B17


"Aaron Neunz" wrote:

I have a range of Cells:
A6:A17
The even numbered cells will always have some text in them.
The odd numbered cells may or may not have any values.
IF(ISBLANK("ALL ODD NUMBERED CELLS IN RANGE"),BLANK,(SOME CALCULATION IF
FALSE)

How would the syntax in ""'s in the above formula look?

Thanks in advance,
Aaron Neunz

I am totaling in cell A18 and need to have the formula in this cell only

"Hayeso" wrote in message
...
In Cell B6 Type

=IF(ISODD(ROW(A6)),IF(ISBLANK(A6),"","Whatever"))
And copy it down through B6:B17


"Aaron Neunz" wrote:

I have a range of Cells:
A6:A17
The even numbered cells will always have some text in them.
The odd numbered cells may or may not have any values.
IF(ISBLANK("ALL ODD NUMBERED CELLS IN RANGE"),BLANK,(SOME CALCULATION IF
FALSE)

How would the syntax in ""'s in the above formula look?

Thanks in advance,
Aaron Neunz

Hi
do you mean
=SUMPRODUCT(--(MOD(ROW(A6:A17),2)=1),A6:A17)

--
Regards
Frank Kabel
Frankfurt, Germany

"Aaron Neunz" schrieb im Newsbeitrag
...
I have a range of Cells:
A6:A17
The even numbered cells will always have some text in them.
The odd numbered cells may or may not have any values.
IF(ISBLANK("ALL ODD NUMBERED CELLS IN RANGE"),BLANK,(SOME CALCULATION
IF
FALSE)

How would the syntax in ""'s in the above formula look?

Thanks in advance,
Aaron Neunz