IF Functions

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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".
 
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>

RobertS said:
I want to display the value of one cell IF the value of another cell is
Click to expand...
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
Click to expand...
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".
 
Back
Top