if conditions in EXCEL

Hi.
Generally, how can we apply an if condition in a column?. For example let
say that I have a column D1:D1000. How can I say in D1001, if all cells
include numbers multiply them (D1*D2*�.D1000), else if one cell include text
or blank then don�t print anything in D1001.
Thank you.

This should give you a start

=IF(OR(ISBLANK(D1:D8),ISTEXT(D1:D8)),"",D1*D2*D3*D4*D5*D6*D7*D8)

Insert as a array Ctrl + Shift + Enter.

=CE=9D=CE=B9=CE=BA=CE=BF=CF=82 wrote:
> Hi.
> Generally, how can we apply an if condition in a column?. For example let
> say that I have a column D1:D1000. How can I say in D1001, if all cells
> include numbers multiply them (D1*D2*=E2=80=A6.D1000), else if one cell i=
nclude text
> or blank then don=E2=80=99t print anything in D1001.
> Thank you.

Hi,

Another way could be to use something like this:

=3DIF(COUNT(D1:D1000)<1000,"",PRODUCT(D1:D1000))

Regards,
Bondi

Hi!

Try this:

=IF(COUNT(D1:D1000)<ROWS(D1:D1000),"",PRODUCT(D1:D1000))

I don't know what kind of numbers might be in the range but multiplying 1000
of them could lead to a huge number.

Biff

"?????" <@discussions.microsoft.com> wrote in message
news:[email protected]...
> Hi.
> Generally, how can we apply an if condition in a column?. For example let
> say that I have a column D1:D1000. How can I say in D1001, if all cells
> include numbers multiply them (D1*D2*..D1000), else if one cell include
> text
> or blank then don't print anything in D1001.
> Thank you.
>

Thanks

Never used Product before

VBA Noob