multi-conditional If Statements

  • Thread starter Thread starter Jennifer
  • Start date Start date
J

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
 
-----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
.
Click to expand...
 
Jennifer

One way:

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

--
Best Regards
Leo Heuser
MVP Excel

Followup to newsgroup only, please.
 
Back
Top