Excel If question....

Closed
nurseydiamond - Aug 8, 2010 at 02:37 PM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Aug 9, 2010 at 02:22 PM
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

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Aug 9, 2010 at 02:22 PM
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
0