View Single Post
  #1   Report Post  
Stephen
 
Posts: n/a
Default Formula of another formula.

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