Hi,

Is there a way to have an if statement based on data type. Here is the
equation I am using.

=IF($F10="",E11,E11+F10)

As you can see I can not add E11 and F10 if F10 is text. I want say
IF($F10="IS TEXT",E11,E11+F10). I hope what I want to do is clear, please
let me know if clarification is needed.

Thanks,

Reed

=IF(ISTEXT($F10),E11,E11+F10)

but it's easier to use:

=SUM(E11,F10)

because SUM will ignore text.

HTH
Jason
Atlanta, GA

-----Original Message-----
Hi,

Is there a way to have an if statement based on data
type. Here is the
equation I am using.

=IF($F10="",E11,E11+F10)

As you can see I can not add E11 and F10 if F10 is
text. I want say
IF($F10="IS TEXT",E11,E11+F10). I hope what I want to
do is clear, please
let me know if clarification is needed.

Thanks,

Reed


.