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! |
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 |