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
|