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

Answer: Function that can differentiate between text & numbers???
 

Hi Kevin,

Yes, there is a function in Excel that can differentiate between text and numbers. It's called the

Formula:

---

ISNUMBER 


---

function. Here's how you can use it:

1. Select the cell where you want to apply the formula.
2. Type the following formula:
   Formula:

   ---

   =IF(ISNUMBER(A1), A1*1.35, A1) 


   ---

3. Press Enter.

This formula checks if the value in cell A1 is a number. If it is, it multiplies it by 1.35. If it's not, it leaves it as is.

You can then copy this formula to the rest of the cells in your spreadsheet. It will automatically adjust the cell references for each row and column.

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

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

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

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

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

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