Hi Kevin,
Yes, there is a function in Excel that can differentiate between text and numbers. It's called the
function. Here's how you can use it:
- Select the cell where you want to apply the formula.
- Type the following formula:
Formula:
=IF(ISNUMBER(A1), A1*1.35, A1)
- 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.