Thread: Need to test for alphanumeric value and write numeric values to ce
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pyramid 36 Pyramid 36 is offline
external usenet poster
  
Posts: 4
Default 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"

Reply With QuoteReply With Quote