Velocity Reviews > -Excel Formula Question

# -Excel Formula Question

Katherine Colby
Guest
Posts: n/a

 01-12-2004
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!

Guest
Posts: n/a

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

Alexander Rogge
Guest
Posts: n/a

 01-12-2004
> 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);"")

marcus@myrealbox.com
Guest
Posts: n/a

 01-12-2004

On Mon, 12 Jan 2004 02:35:19 GMT, Katherine Colby <(E-Mail Removed)>
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