IF Functions

[RobertS]

I want to display the value of one cell IF the value of another cell is within a particular range, but I am apparently making a mistake in the format. For example
IF(G9=30:59, G12, "") which I thought would display the value of G12 if the value in G9 was between the values of 30 through 59. My value happens to be 40, but it is giving me a "False".

 

[Ken Snell]

I think you want an EXCEL newsgroup....this is for ACCESS database product.

However, I believe the correct syntax for this EXCEL formula is this:

IF(AND(G9>=30,G9<=59), G12, "")


--
Ken Snell
<MS ACCESS MVP>

I want to display the value of one cell IF the value of another cell is

within a particular range, but I am apparently making a mistake in the
format. For example:

IF(G9=30:59, G12, "") which I thought would display the value of G12 if

the value in G9 was between the values of 30 through 59. My value happens to
be 40, but it is giving me a "False".