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 D11000. 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.

 

[VBA Noob]

This should give you a start

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

Insert as a array Ctrl + Shift + Enter.

 

[Bondi]

Hi.
Generally, how can we apply an if condition in a column?. For example let
say that I have a column D11000. 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.

Hi,

Another way could be to use something like this:

=IF(COUNT(D11000)<1000,"",PRODUCT(D11000))

Regards,
Bondi

 

[Biff]

Hi!

Try this:

=IF(COUNT(D11000)<ROWS(D11000),"",PRODUCT(D11000))

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

 

[VBA Noob]

Thanks

Never used Product before

VBA Noo