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
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?
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:
- Excel If question....
- Excel mod apk for pc - Download - Spreadsheets
- Gif in excel - Guide
- Number to words in excel - Guide
- Kernel for excel - Download - Backup and recovery
- Excel marksheet - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Aug 9, 2010 at 02:22 PM
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
If the answer is same cell, then you need a macro for that
