IF problems, PLEASE HELP!!!

  • Thread starter Thread starter ryangruhn
  • Start date Start date
R

ryangruhn

Hello,
I am having trouble with "IF"

I need to be able to say:

IF E4 is 0-550: "start up"; 551-650: "moderate";651-850: "gettin
there"; >850: "got there"


How do I write this as a forumla?


Let Me Know
 
try this dude!

=if(and(e4>=0,e4<=550),"start
up",if(and(e4>=551,e4<=650),"moderate",if(e4>=651,e4<=850),"getting
there",if(e4>850),"got there")))
 
=CHOOSE(MATCH(E4,{0,551,651,851,99999999999}),"Start Up","Moderate","Getting
There","Got There")
 
Back
Top