View Single Post
  #1   Report Post  
Reed
 
Posts: n/a
Default IF statement based on data type

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