EASY...for you!

G

Guest

Guest
Trying to build a simple if/then statement measuring ranges. For example:
Cell A1 is greater than 50 but less than 100.
Cell A2 is greater than 100 but less than 500.

I need an if/then statement to say: if A1 is between 50 and 100,then "TRUE", else "false".
 

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.
Thanks for the quickk response. But where does the "and" statement fit into the formula with if/then?

=if(a1>50,"green",if(a1>50,<100,"Blue",0))

Can't seem to get it to work...
 
Upvote 0
=if(a1>50,"green",if(and(a1>50,a1<100),"Blue",0))
 
Upvote 0
LOL, don't confuse me! ROFL...

What color do you want if it is, say 60?

Did you want your first part to be LESS than 50? Just fix my formula above (or Juanito's).
 
Upvote 0
Thanks. i noticed that my example was crap - so i took a stab at something else....green & blue.
 
Upvote 0

Forum statistics

Threads
1,213,560
Messages
6,114,304
Members
448,564
Latest member
ED38

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top