| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
What formula do you use to determine a number within a scale?
Ok heres the deal. I am trying to find an excel formula that will do the
following: Scale is Amount / Factor 170-200 / =1 201-250 / =2 Somehow I need to find a formula that if someone types 190 into a cell, then the cell to the right would have a formula that would calculate a whole number (Factor). Just a brief idea of what I am trying to do... My grandma has diabetes and my mother has asked that I create some kind of form that will factor in how much insulin she must take. So if her Blood Suger is within 170-200, then 1 dose of insulin would be taken.... I appreciate any help you can give me :) God Bless |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
What formula do you use to determine a number within a scale?
Assuming the cell you are entering data into is A1 try
=IF(AND(A1=170,A1<=200),1,IF(AND(A1200,A1<=250), 2,"Out of Range")) Rowan "JessicaHam" wrote: Ok heres the deal. I am trying to find an excel formula that will do the following: Scale is Amount / Factor 170-200 / =1 201-250 / =2 Somehow I need to find a formula that if someone types 190 into a cell, then the cell to the right would have a formula that would calculate a whole number (Factor). Just a brief idea of what I am trying to do... My grandma has diabetes and my mother has asked that I create some kind of form that will factor in how much insulin she must take. So if her Blood Suger is within 170-200, then 1 dose of insulin would be taken.... I appreciate any help you can give me :) God Bless |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
What formula do you use to determine a number within a scale?
Look at excel help on Vlookup. You would build a table of equivalencies and
lookup the entered value. -- Regards, Tom Ogilvy "JessicaHam" wrote in message ... Ok heres the deal. I am trying to find an excel formula that will do the following: Scale is Amount / Factor 170-200 / =1 201-250 / =2 Somehow I need to find a formula that if someone types 190 into a cell, then the cell to the right would have a formula that would calculate a whole number (Factor). Just a brief idea of what I am trying to do... My grandma has diabetes and my mother has asked that I create some kind of form that will factor in how much insulin she must take. So if her Blood Suger is within 170-200, then 1 dose of insulin would be taken.... I appreciate any help you can give me :) God Bless |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date formula to determine the number of days | Excel Worksheet Functions | |||
| Formula to determine number of current records by week | Excel Worksheet Functions | |||
| How do I determine the slope of a logarithmic scale data plot? | Charts and Charting in Excel | |||
| Formula to determine whether number falls within range?? | Excel Worksheet Functions | |||
| HOW-TO: Determine if a cell contains a number vs. formula vs. reference | Excel Programming | |||
Linear Mode
