Re: Multiple Number Ranges Results in Text ('A' if 1-5, 'B' if 6-8, et

Tech-Archive recommends: Fix windows errors by optimizing your registry

"MS Questionnairess" <MSQuestionnairess@xxxxxxxxxxxxxxxxxxxxxxxxx> skrev i
en meddelelse news:EB67FD5E-2E8D-4BEA-A7AE-62EDBA57C24C@xxxxxxxxxxxxxxxx
Ex. A2 is a bunch of numbers that have been conditionally formatted to
show
up as green if between 30 and 34, yellow if between 35 and 45 and red if
46
and over.

However, I need B2 to display the word 'green', 'yellow' or 'red'
depending
on the number range in A2.

Intuitively? Easy. In reality? I'm completely stumped :-P

Help?


Here's one more way to do it.

In B2:

=INDEX({"No color","Green","Yellow","Red"},SUM((A2>={46,35,30,0})+0))



--
Best regards
Leo Heuser

Followup to newsgroup only please.


.

Relevant Pages

  • Re: Fitting Functions
    ... I wonder what "depending on the starting conditions" means. ... Well then actually it's not as good as any other, since chisquare ... that you should do your fitting on log-log axes, ... There's a numerical analysis newsgroup, ...
    (sci.physics)
  • Re: cannot send hotlinks
    ... Please respond in Newsgroup only. ... >> non receipt may be a problem after that, depending on who or what ... If you are depending on "return reciepts" ... >> Jim Pickering, MVP, Outlook Express ...
    (microsoft.public.windows.inetexplorer.ie6_outlookexpress)
  • Re: Trojan horse Scans
    ... > Do you know the IP address of the abuser. ... > this newsgroup to that address. ... Depending on how sensitive ZoneAlarm is, it might be a faked connection ...
    (comp.security.firewalls)
  • Re: lcc first experience
    ... to this newsgroup treat it with a fetishistic reverence and try to make ... it into something it isn't doesn't change the reality. ... Not everything, for instance the newsreader I'm typing this into couldn't be written under such a system, but most of my programs work exactly like that. ...
    (comp.lang.c)
  • Re: aes decrypt encrypt
    ... For Cathy the funding's familiar, plus me it's profitable, whereas ... depending on you it's hunting firm. ... reality, if Marla slightly puts the exemption? ... They are squeezing depending on the lodge now, ...
    (sci.crypt)