URGENT! I really need an Answer!

[jpbonono]

The conditions are:

There are multiple reference cells and all of those should be number, if one becomes a letter or not a number, it would prompt, "ERROR" or "FALSE" or "INVALID", if in case all cells are numbers, it would proceed to SUM it all up.

I've tried IF with ISNUMBER function but it only works with a single cell/value.

Please help.

Thanks.

 

[jpbonono]

up

 

[jpbonono]

up

 

[jpbonono]

up

 

[Oeldere]

This looks to me, as an duplicated post.

 

[Aladin Akyurek]

The conditions are:

There are multiple reference cells and all of those should be number, if one becomes a letter or not a number, it would prompt, "ERROR" or "FALSE" or "INVALID", if in case all cells are numbers, it would proceed to SUM it all up.

I've tried IF with ISNUMBER function but it only works with a single cell/value.

Please help.

Thanks.

What is the range of interest?

 

[jpbonono]

@Oeldere, Its not sir, the other one is regarding an exceeding of number from the ref cell, this one is if the group of cell should only contain numbers and if one has letter or not a number it would prompt invalid. If the conditions were met the numbers on the cell would be added.

@aladin, I'm not really good in excel, what do you mean by the range of interest?

 

[Aladin Akyurek]

@Oeldere, Its not sir, the other one is regarding an exceeding of number from the ref cell, this one is if the group of cell should only contain numbers and if one has letter or not a number it would prompt invalid. If the conditions were met the numbers on the cell would be added.

@aladin, I'm not really good in excel, what do you mean by the range of interest?

A2:A4 is a range example. So I was asking waht is the range we have to test/look at?

 

[jpbonono]

.

 

[jpbonono]

@Aladin, P6,AD6,AR6,BF6. These cells should only contain numbers, if that so, then it will be added. While if one of this cell has changed into letter or not a number, it'll prompt Invalid or Error. Hope this would help.