If statement formula wont calculate numbers

[dr.L]

Let's say...
i have a statement like =IF(AND((B4>=0),(B4<5)),"600" in cell D4.
Then i have =average(d4:d6)

it says, 600 in D4 when b4 is between 0 and 5 but how can i get that number to be calculated with other numbers. Its like it wont recognize the numerical value of the if statement to further calculate

 

[Jose_Chasez]

Remove the quotation marks from around the 600 and Excel will recognize it as a numeric value.

 

[mgm05267]

Hi dr.L,

Welcome to the Board..

in D4 change the formula to =IF(AND((B4>=0),(B4<5)),600,0)

 

[T. Valko]

Let's say...
i have a statement like =IF(AND((B4>=0),(B4<5)),"600" in cell D4.
Then i have =average(d4:d6)

it says, 600 in D4 when b4 is between 0 and 5 but how can i get that number to be calculated with other numbers. Its like it wont recognize the numerical value of the if statement to further calculate

Remove the quotes from around 600 in your IF formula. When you quote numbers Excel evaluates them as TEXT and as such will be ignored by the AVERAGE function.

 

[dr.L]

AH your a saint thank you!