Stephen,

It's likely to be casued be the rounding of the displayed value. Try

=IF(ROUND(A1,0)<=35,.......

HTH,
Bernie
MS Excel MVP


"Stephen" wrote in message
...
Hi. I often have problems calculating an answer using a formula that has
to
reference another formula. Why is this??

My current problem is, I have a conditional statement saying if cell a1
(for
example) is <=35, then 3, <=44, then 4, etc. Cell a1 has a formula that
grabs
data from another sheet. When it grabs 35 for example it is ignoring the =
of
the <= and gives me 4, it should be 3. How come the <= is interpreted as
just
< and why do I always have problems referencing other formulas in current
formulas?
Thanks!

--
Thanks!

Stephen