Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
#6
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Simplify formula | Excel Worksheet Functions | |||
put formula results into a different cell if it is empty | Excel Worksheet Functions | |||
Dynamic (?) formula | Excel Worksheet Functions | |||
how do i write a formula and keep in in formula form, so it DOESN. | Excel Discussion (Misc queries) | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |