Excel help

[Redwood]

Excel gurus,

Does anyone know if this is possible? I'm trying to compare use an IF statement to check a numeric value in a cell and then output to a true\false scenario depending on that value.

The only trouble is I need to use two comparison opertaors, so I need to check that the number is greater than or equal to one number, AND less than another number. Is this possible?

Cheers

 

[Region3]

Not sure I understand properly, but you can use AND inside an IF formula.

Say your number is in A1 and you want to make sure it's bigger than or equal to B1, and less than C1.

=IF(AND(A1>=B1,A1<C1),"TRUE","FALSE")

Does that help?

 

[Redwood]

Cheers Gary,

Let me try it.

 

[Redwood]

Thanks mate, worked a treat.

 

[Leftie]

Beat me to it

 

[Region3]

Beat me to it

As Leftie was about to point out, you don't even need the IF formula.

If you just type a statement without IF, your result will be TRUE or FALSE.

So if you were to type =5=7
you are basically saying 5=7, so your cell would show FALSE, because it is.

Using that, your formula from above could be

=AND(A1>=B1,A1<C1)

and Excel will choose TRUE of FALSE for you.

 

[bobmac]

As Leftie was about to point out, you don't even need the IF formula.

If you just type a statement without IF, your result will be TRUE or FALSE.

So if you were to type =5=7
you are basically saying 5=7, so your cell would show FALSE, because it is.

Using that, your formula from above could be

=AND(A1>=B1,A1<C1)

and Excel will choose TRUE of FALSE for you.

What was the questioon again?

 

[Redwood]

Good to know. I did need it to show some specific text though depending on the values.

OK, I'll own up, I'm being a saddo and putting together a spreadsheet with my clubs scorecard and scores and working out gross\net scores, plus stableford scores and what Cat you are etc.... and a few graphs for good measure!!!