| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with "if"
Thank you
"Steven_Archer" wrote: Hi, The formula below should work - =IF((AND(B46,B4<8)),\"TRUE\",\"FALSE\") Where B4 is the cell where the number is. So what the formula is saying is if B4 is greater than 6 and less than 8 then enter "True", otherwise enter "False". This formula will show 6 and 8 as "false". If you want to change it to show 6 and 8 as true change the formula to : =IF((AND(B4=6,B4<=8)),\"TRUE\",\"FALSE\") hope this answers your question Steven -- Steven_Archer ------------------------------------------------------------------------ Steven_Archer's Profile: http://www.excelforum.com/member.php...o&userid=29025 View this thread: http://www.excelforum.com/showthread...hreadid=487581 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| please can you tell me how to use the "if" function (new user) | New Users to Excel | |||
| Can "IF" function display calculated data as bold? | Excel Worksheet Functions | |||
| Can't make Excel "if" Formula work | Excel Worksheet Functions | |||
| return data in multiple columns using "if"? | Excel Discussion (Misc queries) | |||
| The "IF" Statement | Excel Worksheet Functions | |||
Threaded Mode
