If you are getting 730 for every line, one possibility is that you've got
text, rather than numbers, in the relevant cells. What do you get from the
formulae =ISTEXT(A2) and =ISNUMBER(A2) ? If you have got text, you'll need
to convert to numbers. You might get away with one or more of the following
options:
Copy a blank cell, then select your range of cells which need converting and
Edit/ Paste Special/ Add
Data/ Text to columns

Look out for spaces, non-breaking spaces, or other non-printing characters
and delete them.
--
David Biddulph


"jenn" wrote in message
...
ok, so I read it before... blew right past it in a huff... re read it...
and
thought I understood... but my current formula returns "730" as the
result
for every line:

=IF(A2=730,"730",IF(A2=545,"545-729",IF(A2365,"365-544",IF(A2180,"180-365",IF(A20,"<180")))))

"David Biddulph" wrote:

It looks as if you haven't read the replies which Fred and I gave
earlier?

Try changing your formula to
=IF(A2=730,730,IF(A2545,"545-730",IF(A2=365,"365-545",IF(A2180,"180-365","<180"))))

You may want to look again at whether you want or =, as you seem to
have
been inconsistent.

The syntax of IF is very simple. It has 3 arguments, the first being a
condition, the second is the outcome if the condition is true, and the
third
is the outcome if the condition is false (and the outcome defaults to a
value of FALSE if you don't give that third argument). The nesting comes
in
if you decide that you want to replace one outcome or the other (or both)
by
a further formula. Remember that if the first test is satisfied, you
don't
go on to any tests which might be in the alternative (third argument)
path,
so you don't need to test again. Look at what I said in my reply
earlier.
--
David Biddulph

"jenn" wrote in message
...
=IF(A2=730,730,IF(A2545,A2<730,"545-730"),IF(A2=365,A2<545,"365-545",IF(A2<365,A2180,"180-365"),IF(A2<180,"<180"))))

Its supposed to look at the data in A2 and if it is greater than 730
display
730
if the number in A2 is between 545 and 730 display 545 - 730

etc

I've gotten it to work before, but the above is telling me there are
too
many arguments and my nested experience is weak.

thanks!

"Fred Smith" wrote:

You still haven't told us everything you need. And your use of quotes
doesn't make any sense -- ie, we can't tell if you want your results
to
be
numbers of text. Finally, what do you want to happen when A2 is
between
365
and 545?

This syntax works, so maybe it will point you in the right direction:

=if(a2=730,730,if(and(a2545,a2<730),a2,if(a2=36 5,365,if(and(a2<365,a2180),a2,0))))

Regards,
Fred.



"jenn" wrote in message
...
I can not seem to get the syntax right.

=if(AND((A2730,"730),(A2545,A2<730,"545-730"),(A2<365,A2<180,"180-365)))...


basically... if 730 then 730
if between 545 and 730 then '545-730