-Excel Formula Question

Discussion in 'Computer Support' started by Katherine Colby, Jan 12, 2004.

1. Katherine ColbyGuest

I'm trying to create an IF state like the one below to specify a
number "Between 0 & 180". Here is the formula that is incorrect. Can
anyone show me the correct syntax for the formula?

What I'm trying to say is"

If H3-C3 is greater than 0, but less than 180, L3-G3, otherwise leave
the cell blank.

=IF((H3-C3),>0&<180,(L3-G3)," ")

Thanks!

Katherine Colby, Jan 12, 2004

Katherine Colby said:

> I'm trying to create an IF state like the one below to specify a
> number "Between 0 & 180". Here is the formula that is incorrect. Can
> anyone show me the correct syntax for the formula?
>
> What I'm trying to say is"
>
> If H3-C3 is greater than 0, but less than 180, L3-G3, otherwise leave
> the cell blank.
>
> =IF((H3-C3),>0&<180,(L3-G3)," ")
>
> Thanks!

If Excel was "intelligent", Lieutenant Commander Data would have been named
Sub-Ensign ( ensign/standard ;-) ) Info.

3. Alexander RoggeGuest

> I'm trying to create an IF state like the one below to specify a
> number "Between 0 & 180".
>
> If H3-C3 is greater than 0, but less than 180, L3-G3, otherwise leave
> the cell blank.

=IF((H3-C3)<180 AND (H3-C3)>0;(L3-G3);"")

Alexander Rogge, Jan 12, 2004
4. Guest

On Mon, 12 Jan 2004 02:35:19 GMT, Katherine Colby <>
wrote:

>=IF((H3-C3),>0&<180,(L3-G3)," ")

The & is only used for connecting pieces of text.

The correct formula should be:

=IF(AND(H3-C3>0,H3-C3<180),(L3-G3)," ")

Hope this helps

regards
Marcus

, Jan 12, 2004