Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Numbers in a formula!
This may sound daft but i'm baffled! I have an IF formula shown below:
=IF(T4= ,"Level 4","") in the large gap above I would like to place the numbers 9 through to 13. I wish to add these because I want the text "Level 4" to appear only when the numbers 9 through 13 are in a box. But when I try: =IF(T4=9:13,"Level 4","") it trys to use cells 9:13 not numbers! Help please! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Numbers in a formula!
Try the below
=IF(MEDIAN(9,T4,13)=T4,"Level 4","") If this post helps click Yes --------------- Jacob Skaria "Shadowdw" wrote: This may sound daft but i'm baffled! I have an IF formula shown below: =IF(T4= ,"Level 4","") in the large gap above I would like to place the numbers 9 through to 13. I wish to add these because I want the text "Level 4" to appear only when the numbers 9 through 13 are in a box. But when I try: =IF(T4=9:13,"Level 4","") it trys to use cells 9:13 not numbers! Help please! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Numbers in a formula!
Another way.......
=LOOKUP(A1,{0,9,14},{"","Level 4",""}) Vaya con Dios, Chuck, CABGx3 "Shadowdw" wrote: This may sound daft but i'm baffled! I have an IF formula shown below: =IF(T4= ,"Level 4","") in the large gap above I would like to place the numbers 9 through to 13. I wish to add these because I want the text "Level 4" to appear only when the numbers 9 through 13 are in a box. But when I try: =IF(T4=9:13,"Level 4","") it trys to use cells 9:13 not numbers! Help please! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Numbers in a formula!
Try this...
=IF(AND(T4=9,T4<=13),"Level 4","") -- Biff Microsoft Excel MVP "Shadowdw" wrote in message ... This may sound daft but i'm baffled! I have an IF formula shown below: =IF(T4= ,"Level 4","") in the large gap above I would like to place the numbers 9 through to 13. I wish to add these because I want the text "Level 4" to appear only when the numbers 9 through 13 are in a box. But when I try: =IF(T4=9:13,"Level 4","") it trys to use cells 9:13 not numbers! Help please! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Numbers in a formula!
Given your list of values is short, here is yet another way...
=IF(OR(T4={9,10,11,12,13}),"Level 4","") -- Rick (MVP - Excel) "Shadowdw" wrote in message ... This may sound daft but i'm baffled! I have an IF formula shown below: =IF(T4= ,"Level 4","") in the large gap above I would like to place the numbers 9 through to 13. I wish to add these because I want the text "Level 4" to appear only when the numbers 9 through 13 are in a box. But when I try: =IF(T4=9:13,"Level 4","") it trys to use cells 9:13 not numbers! Help please! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula for numbers | Excel Worksheet Functions | |||
Excel Formula - Add column of numbers but ignore negative numbers | Excel Worksheet Functions | |||
Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up? | Excel Worksheet Functions | |||
Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up? | Excel Worksheet Functions | |||
I PUT A FORMULA IN A CELL BUT I DON'T GET NUMBERS BUT THE FORMULA | Excel Worksheet Functions |