IF statement based on data type

  • Thread starter Thread starter Reed
  • Start date Start date
R

Reed

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
 
Back
Top