| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need to test for alphanumeric value and write numeric values to ce
The cell B2 has a data validation list of W2, 1099, or B2B and I want to
write two different values to B14 & B15 if users select the value W2, and if anything else is selected, then write zeros to the same two cells. I've tried the following: =IF(B2="w2"), (B14=1.1235,B15=6.35),(B14=0,B15=0) The error message I get highlights "w2" as an error when I try to enter this. -- Pyramid 36 "Ken" |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to test for a specific text string and write value to another | Excel Worksheet Functions | |||
| Extract numeric part of alphanumeric cell | Excel Worksheet Functions | |||
| can i write a macro to truncate alpha-numeric data? | Excel Discussion (Misc queries) | |||
| Converting Alphanumeric numbers to Numeric | Excel Worksheet Functions | |||
| Test IF Two Numeric Values Match (from two separate Dynamic Ranges) | Excel Worksheet Functions | |||
Threaded Mode
