if conditions in EXCEL

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Νικος - 17 Jul 2006 06:52 GMT

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.

Reply to this Message

VBA Noob - 17 Jul 2006 07:15 GMT

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.

Signature

VBA Noob

Reply to this Message

Bondi - 17 Jul 2006 07:39 GMT

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*.D1000), else if one cell include text
> or blank then dont print anything in D1001.
> Thank you.

Hi,

Another way could be to use something like this:

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

Regards,
Bondi

Reply to this Message

Biff - 17 Jul 2006 07:41 GMT

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

> Hi.
> Generally, how can we apply an if condition in a column?. For example let
[quoted text clipped - 3 lines]
> or blank then don't print anything in D1001.
> Thank you.

Reply to this Message

VBA Noob - 17 Jul 2006 07:59 GMT

Thanks

Never used Product before

VBA Noo

Reply to this Message