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
|