Forum Discussion

Scott Cackett's avatar
Scott Cackett
Copper Contributor
Dec 11, 2017

Excel Formula help needed

Hi everyone, I am trying to create a formula to help me increase/decrease insulin levels to help treat my diabetes. Hopefully this makes sense. I need a formula to do the below:   If a number...
Formulas & Functions
Need Help
Haytham Amairah's avatar
Haytham Amairah
Silver Contributor
Dec 11, 2017

Scott,

 

What you need is something like this:

 

=IF(AND(A1>=-2,A1<=2),"No Change",
  IF(AND(A1<-2,A1>=-4),"-0.1",
  IF(AND(A1<-4,A1>=-6),"-0.2",
  IF(AND(A1>2,A1<=4),"+0.1",
  IF(AND(A1>4,A1<=6),"+0.2",
  IF(OR(A1>6,A1<-6),"Review"))))))

 

Scott Cackett's avatar
Scott Cackett
Copper Contributor
Dec 11, 2017

thanks, looks like it's working perfectly!!

Resources