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.

 

[jamilm]

this one is a cool trick too. thx Robert

If all of the cells will always be populate with either a number or text then this formula should work...

=IF(OR(ISTEXT(P6),ISTEXT(AD6),ISTEXT(AR6),ISTEXT(BF6)),"ERROR",SUM(P6,AD6,AR6,BF6))

If any of the cells can be blank/null OR text then you would probably want to use this...

=IF(AND(ISNUMBER(P6),ISNUMBER(AD6),ISNUMBER(AR6),ISNUMBER(BF6)),SUM(P6,AD6,AR6,BF6),"ERROR")

I hope this helps

 

[jpbonono]

How logical! Thank you! This one is easier to understand Thank you RobertCotton!

If all of the cells will always be populate with either a number or text then this formula should work...

=IF(OR(ISTEXT(P6),ISTEXT(AD6),ISTEXT(AR6),ISTEXT(BF6)),"ERROR",SUM(P6,AD6,AR6,BF6))

If any of the cells can be blank/null OR text then you would probably want to use this...

=IF(AND(ISNUMBER(P6),ISNUMBER(AD6),ISNUMBER(AR6),ISNUMBER(BF6)),SUM(P6,AD6,AR6,BF6),"ERROR")

I hope this helps