View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default Function that can differentiate between text & numbers???

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Kevin" wrote in message
...
Thank you. This worked great!!

"T. Valko" wrote:

Try this:

=IF(ISTEXT(A1),A1,IF(COUNT(A1),IF(A11,A1*1.35,A1) ,""))

--
Biff
Microsoft Excel MVP


"Kevin" wrote in message
...
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(A11, 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