Hi,

Is there a way to read the value of a cell that has a formula in it? I have
one cell who's formula reads the value of other cells, but some of those
other cells would have formula's in them. Is this possible? Thank you

Yes, of course. Formula cells can point to & read the returns of yet other
formula cells. Eg: you may have in C1: =SUM(A1:B1) - which returns the sum of
the values entered in A1 and B1. And you could then have in D1:
=IF(C1=0,"",C1) - which checks whether the formula in C1 returns a zero, and
if so, D1 will in turn return a neat "blank", ie: "", otherwise D1 will
simply return the value computed in C1.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Hell-fire" wrote:
Hi,

Is there a way to read the value of a cell that has a formula in it? I have
one cell who's formula reads the value of other cells, but some of those
other cells would have formula's in them. Is this possible? Thank you

Hi Max,

Thank you for responding to my post. The problem is, when I use the formula
in the one cell, the other cell isn't reading properly. If I take out the
formula and just place a value in it, it works.

The main cell formula is this:
=IF(AX446=1,IF(OR(AF446="A",AF446="V"),IF(AZ446=" —‹",IF(BA446="-","Ｆ","ï¼¢"),IF(BA446="—‹","I","X")),""),IF(AX4 46=1.1,IF(OR(AF446="A",AF446="V"),"1"&IF(AZ446="— ‹",IF(BA446="-","F","ï¼¢"),IF(BA446="—‹","I","X")),""),""))

The other cell I want read has this formula:
=IF(AX446=1.1,"-",IF(AND(AX446=1,AF446="A"),"—‹",IF(AND(AX446=1,A F446)="V","-"," ")))

If I have the above formula in the cell, the main formula doesn't seem to
read the "A" or "V" in a different cell. I hope this makes sense. Thank you


"Max" wrote:

Yes, of course. Formula cells can point to & read the returns of yet other
formula cells. Eg: you may have in C1: =SUM(A1:B1) - which returns the sum of
the values entered in A1 and B1. And you could then have in D1:
=IF(C1=0,"",C1) - which checks whether the formula in C1 returns a zero, and
if so, D1 will in turn return a neat "blank", ie: "", otherwise D1 will
simply return the value computed in C1.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Hell-fire" wrote:
Hi,

Is there a way to read the value of a cell that has a formula in it? I have
one cell who's formula reads the value of other cells, but some of those
other cells would have formula's in them. Is this possible? Thank you

Perhaps it's just a syntax typo in this formula of yours tripping things up:
=IF(AX446=1.1,"-",IF(AND(AX446=1,AF446="A"),"—‹",IF(AND(AX446=1,A F446)="V","-"," ")))

Try correcting it to read as:
=IF(AX446=1.1,"-",IF(AND(AX446=1,AF446="A"),"—‹",IF(AND(AX446=1,A F446="V"),"-"," ")))

Hopefully that will clear it up for you.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Hell-fire" wrote:
Hi Max,

Thank you for responding to my post. The problem is, when I use the formula
in the one cell, the other cell isn't reading properly. If I take out the
formula and just place a value in it, it works.

The main cell formula is this:
=IF(AX446=1,IF(OR(AF446="A",AF446="V"),IF(AZ446=" —‹",IF(BA446="-","Ｆ","ï¼¢"),IF(BA446="—‹","I","X")),""),IF(AX4 46=1.1,IF(OR(AF446="A",AF446="V"),"1"&IF(AZ446="— ‹",IF(BA446="-","F","ï¼¢"),IF(BA446="—‹","I","X")),""),""))

The other cell I want read has this formula:
=IF(AX446=1.1,"-",IF(AND(AX446=1,AF446="A"),"—‹",IF(AND(AX446=1,A F446)="V","-"," ")))

If I have the above formula in the cell, the main formula doesn't seem to
read the "A" or "V" in a different cell. I hope this makes sense. Thank you

Hi Max,

Thanks for the response. I changed it, but if I type in 1.0, there is no
problem for the A and V. If I type in 1.1 though, it still not reading A.
If Ican't get it right, then the user will just have to fill in that cell
manually. Thanks again.


"Max" wrote:

Perhaps it's just a syntax typo in this formula of yours tripping things up:
=IF(AX446=1.1,"-",IF(AND(AX446=1,AF446="A"),"—‹",IF(AND(AX446=1,A F446)="V","-"," ")))

Try correcting it to read as:
=IF(AX446=1.1,"-",IF(AND(AX446=1,AF446="A"),"—‹",IF(AND(AX446=1,A F446="V"),"-"," ")))

Hopefully that will clear it up for you.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Hell-fire" wrote:
Hi Max,

Thank you for responding to my post. The problem is, when I use the formula
in the one cell, the other cell isn't reading properly. If I take out the
formula and just place a value in it, it works.

The main cell formula is this:
=IF(AX446=1,IF(OR(AF446="A",AF446="V"),IF(AZ446=" —‹",IF(BA446="-","Ｆ","ï¼¢"),IF(BA446="—‹","I","X")),""),IF(AX4 46=1.1,IF(OR(AF446="A",AF446="V"),"1"&IF(AZ446="— ‹",IF(BA446="-","F","ï¼¢"),IF(BA446="—‹","I","X")),""),""))

The other cell I want read has this formula:
=IF(AX446=1.1,"-",IF(AND(AX446=1,AF446="A"),"—‹",IF(AND(AX446=1,A F446)="V","-"," ")))

If I have the above formula in the cell, the main formula doesn't seem to
read the "A" or "V" in a different cell. I hope this makes sense. Thank you

It seems ok to me.

Maybe just take a look at this test file:
http://cjoint.com/?jelJ5hCKXj
hellfire_wks.xls

Post back on what's the problem you have with the "main cell"'s formula
returns (easier to see things with the test file)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Hell-fire" wrote:
Hi Max,

Thanks for the response. I changed it, but if I type in 1.0, there is no
problem for the A and V. If I type in 1.1 though, it still not reading A.
If I can't get it right, then the user will just have to fill in that cell
manually. Thanks again.