| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How would I do a formula for this?
How do I set up a formula that will do than one number but <than another
number will equal something. Like 4.5 but <7 in one cell will = 10 in this cell. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How would I do a formula for this?
On Jan 9, 12:49 pm, Mike wrote:
How do I set up a formula that will do than one number but <than another number will equal something. Like 4.5 but <7 in one cell will = 10 in this cell. Possibly... =IF(AND(A14.5,A1<7),10,"") which tests if A1 is between 4.5 and 7 (Not including 4.5 or 7) then makes the cell with the formula 10 when the test is true and blank,"", when false. Ken Johnson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How would I do a formula for this?
On Jan 9, 1:00 pm, Ken Johnson wrote:
On Jan 9, 12:49 pm, Mike wrote: How do I set up a formula that will do than one number but <than another number will equal something. Like 4.5 but <7 in one cell will = 10 in this cell. Possibly... =IF(AND(A14.5,A1<7),10,"") which tests if A1 is between 4.5 and 7 (Not including 4.5 or 7) then makes the cell with the formula 10 when the test is true and blank,"", when false. Ken Johnson You can even get away without using any worksheet functions... =(A14.5)*(A1<7)*10 which returns 10 when test is true and 0 when false Ken Johnson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
