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

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

Hi Stephen,
without the formula and the values of the referred to cells it is kind
of hard to figure out what you have, and what you want.

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"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

Hi Stephen,

What looks like 35 may actually be 35.000000000001
Test by temporarily changing the format to something like 0.000000000000000

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"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

I would guess that your 35 is *not* 35.

It may be 35.01, but your formatting is dropping the extra decimal places.

You can round off the formula in the sheet that originates the 35.

For example:

A1 = 12
B1 = 2.918

Formula in C1:
=A1*B1
Returns 35.016

Rounding formula:
=ROUND(A1*B1,0)
Returns 35
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"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

Bernie,

Using Round fixed it. I bet that has been my problem on all of the formulas
I use = or <=.

Thanks again!
--
Thanks!

Stephen


"Bernie Deitrick" wrote:

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