Excel If question....

[Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,

I need help with an excel spreadsheet and an IF statement. I have 5 columns with numbers from 0 through 9. If the value in the cell is "0," instead of "0," I want the cell to display "KP 0" If it is any value from 1 through 9, instead of just what the value is, I want it to display, "Keypad (whatever the value is from 1-9)" like this: "Keypad 1" or "Keypad 7" etc.

Can someone help me withthe correct formula?

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
Do you want same cell to show "KP 0" where it used to show "0 " before ? or some other cell.

If the answer is same cell, then you need a macro for that