Formula of another formula.

[Guest]

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!

 

[Bernie Deitrick]

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

 

[David McRitchie]

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.

 

[Niek Otten]

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

 

[RagDyeR]

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!
==============================================

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!

 

[Guest]

Bernie,

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

Thanks again!
--
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