Previous Topic Next Topic

Excel If question....

Closed
nurseydiamond - Aug 8, 2010 at 02:37 PM
rizvisa1 Posts 4478 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?
Related:

1 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
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

Similar discussions

Keyboard troubles
jimbobjoe -
car -

38 responses
Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses