If statement

[Closed]
Report
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
Hello, i am have a hard time getting the result for each number in shink with the description. excel returns "CYCLE COUNT" in all the cells.
Can you help me?
=IF((C$2=11),"CYCLE COUNT",IF((C$2=26),"SHORT ON TRUCK",IF((C$2=51),"RETURN TO VENDOR",IF((C$2=32),"WAREHOUSE DAMAGE",IF((C$2=77),"FROZEN",IF((C$2=28),"CHEMICALS & CLEANING",IF((C$2=39),"FROZEN FOOD PROCESS",IF((C$2=86),"PRODUCE",))))))))

1 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
803
remove that dollar sign in the formula. with the dollar sign it tests only C2 in all cases if the data is in column C
how to do this easily
highlight the cell with the formula
click control+H
in the " find what" window type
$
in "replace with" window leave it blank
click "replac eall" at the bottom
all the dollars will be removed.

get back to the newsgroup if this solves the problem