=IF(logical_test,value_if_true,value_if_false)

=IF(AND(x20,x<40),5,"Something else")

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"Margaret" wrote in message
...
How do I write an inequality in excel? For example, if 20<x<40 then write
5
in the