View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jason Jason is offline
external usenet poster
 
Posts: 367
Default Multiple IF THEN criteria...

=IF(B20="r","-2",IF(B20="5","-1",IF(B20="=","1","")))

The "5" displays blank, all the others work... any reason why?

I am trying to be get so if in B20 someone enter's r "-2" diplays; 5 "-1"
diplays; = "-2" diplays; and if they enter nothing then nothing displays.

thank you!