Function that can differentiate between text & numbers???

[Kevin]

I have a spreadspread that contains both text and numbers in every column and
row. The values are in euro. I usually copy the spreadsheet over and multiply
the values by the exchange rate.
Example:
88 98 n/a 50
78 n/a 45 51
I have tried using the IF function, IF(A1>1, A1*1.35, A1), but this returns
the #VALUE symbol in the cells that contain words.
Is there function that would allow me to copy it throughout the whole
spreadsheet, returning new values for cells with numbers and leaving all
cells with text exactly the way are?
Thank you for any help you could provide!!
Kevin

 

[T. Valko]

Try this:

=IF(ISTEXT(A1),A1,IF(COUNT(A1),IF(A1>1,A1*1.35,A1),""))

 

[Luke M]

Try this:

=IF(AND(ISNUMBER(A1),A1>1),A1*1.35,A1)

 

[Kevin]

This is exactly what I have been trying to do. It worked perfectly! You have
saved me hours of work!! Thank you!!

 

[Kevin]

Thank you. This worked great!!

Try this:

=IF(ISTEXT(A1),A1,IF(COUNT(A1),IF(A1>1,A1*1.35,A1),""))

 

[T. Valko]

You're welcome. Thanks for the feedback!

 

[Rick Rothstein]

Here is a shorter formula for you to try...

=IF(N(A1)=0,A1,1.35*A1)