Home 
Search 
Today's Posts 
#1




Function that can differentiate between text & numbers???
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 
#2




Function that can differentiate between text & numbers???
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 
#3




Function that can differentiate between text & numbers???
Try this:
=IF(AND(ISNUMBER(A1),A11),A1*1.35,A1)  Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Kevin" wrote: 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 
#4




Function that can differentiate between text & numbers???
This is exactly what I have been trying to do. It worked perfectly! You have
saved me hours of work!! Thank you!! "Luke M" wrote: Try this: =IF(AND(ISNUMBER(A1),A11),A1*1.35,A1)  Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Kevin" wrote: 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 
#5




Function that can differentiate between text & numbers???
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 
#6




Function that can differentiate between text & numbers???
You're welcome. Thanks for the feedback!
 Biff Microsoft Excel MVP "Kevin" wrote in message news 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 
#7




Function that can differentiate between text & numbers???
Here is a shorter formula for you to try...
=IF(N(A1)=0,A1,1.35*A1)  Rick (MVP  Excel) "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 
Reply 
Thread Tools  Search this Thread 
Display Modes  


Similar Threads  
Thread  Forum  
How to differentiate groups of numbers  Excel Worksheet Functions  
Using a function with numbers & text  New Users to Excel  
How do I set up an IF function with text and numbers?  Excel Worksheet Functions  
How do I use COUNTIF in a SUBTOTAL function to differentiate the .  Excel Worksheet Functions  
numbers to text function  Excel Worksheet Functions 