multi-conditional If Statements

[Jennifer]

I'm doing a spreadsheet that I need excel to return a
value if a given cell is between stated values. How do I
write the if statement with multiple conditions?
Basically, I need it to read:

If cell#1 >=1 and <50 then return x else return 0.

anybody? Anybody? Bueller?

Jenn

 

[Andy]

Jennifer

One way:
=IF(AND(cell>=1,cell<50)"x",0)

Andy

 

[AO]

-----Original Message-----
I'm doing a spreadsheet that I need excel to return a
value if a given cell is between stated values. How do I
write the if statement with multiple conditions?
Basically, I need it to read:

If cell#1 >=1 and <50 then return x else return 0.

anybody? Anybody? Bueller?

Jenn
.

 

[Leo Heuser]

Jennifer

One way:

=IF(AND(cell#1>=1, cell#1<50), x, 0)

--
Best Regards
Leo Heuser
MVP Excel

Followup to newsgroup only, please.

 

[Dave Peterson]

The Hawley-Smoot Tariff Act

http://us.imdb.com/Quotes?0091042

 

[Allan Rogg]

=IF(AND(A1>=1,A1<50),"x",0)

Allan Rogg