| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Changing lookup form numbers to alphabetics
I am using this formula (=IF(G27+K270,1,0) tocheck to see if one or both
columns have a number field entered, returning 1 if either/both and zero if neither completed. I want to change the formula to check to see if either of two cells have an x instead of the 1, putting an x if either/both previous fields are checked, ond blank if neither is checked. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I stop excel from changing single numbers like 1 into a de. | Excel Discussion (Misc queries) | |||
| Trying to delete form border, and it deletes all borders | Excel Discussion (Misc queries) | |||
| How do I stop Excel from changing simple numbers to their 1/100th. | Excel Discussion (Misc queries) | |||
| Average/Min column of numbers, but skip 0's and Null's in the form | Excel Worksheet Functions | |||
| double lookup, nest, or macro? | Excel Worksheet Functions | |||
Threaded Mode
