Re: If And statements -- HELP!
- From: "Sandy Mann" <sandymann2@xxxxxxxxxxxxxx>
- Date: Wed, 14 Mar 2007 13:51:35 -0000
Hi GI JOE,
No there is no way that I know of to turning off the circular reference.
You can turn Iteration on or off but that does not stop the circular
references and your
Perhaps if you explain what it is that you are trying to do some of the
clever people around here will be able to give you an alternarive or work
around.
--
Regards,
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
sandymann2@xxxxxxxxxxxxxx
Replace@xxxxxxxxxxxxxx with @tiscali.co.uk
"GI JOE" <GIJOE@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:39B7315B-9009-4574-9B77-173F2EC724FA@xxxxxxxxxxxxxxxx
Good morning Sandy (Toronto Time)
Thank you for your help... Is there a way to turn off the circular
reference
in order for the value to appear?
Joe.
"Sandy Mann" wrote:
I may be wrong but is it not the circular reference that is stopping the
formulas calculating?
--
HTH
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
sandymann2@xxxxxxxxxxxxxx
Replace@xxxxxxxxxxxxxx with @tiscali.co.uk
"GI JOE" <GIJOE@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:D7B1C03C-FAAB-4028-A7FA-391BA74F2A57@xxxxxxxxxxxxxxxx
I just checked the fx icon next to the formula bar and it indicates the
correct formula outcome so now I'm totally confused!
Why would the outcome not show up in the cell?
"GI JOE" wrote:
I don't understand why this formula does not work
Cell D 10 is =IF(B10>=1,$G$72,(IF(AND(D11=0,D9=$G$72),$G$71,0)))
Cell D 11 is =IF(B11>=1,$G$72,(IF(AND(D12=0,D10=$G$72),$G$71,0)))
Cell D 12 is =IF(B12>=1,$G$72,(IF(AND(D13=0,D11=$G$72),$G$71,0)))
If I check off display zero values in my options menu then I do see a
zero
in the cell but the formula does not read it as a zero. The only way
I
know
it doesn't is when I type in a zero in cell D 12 then cell D 11 reacts
the
way I expect it to.... Is there something I don't understand about
formula
writing or is this one of those so called glitches?
This is what it looks like when the formula is working on its own
Total Kms for the Day 76
___________________________________________
This is what it looks like when I type in a zero in cell D 12
Total Kms for the Day 76
Total Kms to date 76
0
.
- Follow-Ups:
- Re: If And statements -- HELP!
- From: GI JOE
- Re: If And statements -- HELP!
- References:
- Re: If And statements -- HELP!
- From: Sandy Mann
- Re: If And statements -- HELP!
- Prev by Date: Re: Saving without deleting previous input
- Next by Date: Re: I have 2 identical workbooks within 1 file, how do I delete 1?
- Previous by thread: Re: If And statements -- HELP!
- Next by thread: Re: If And statements -- HELP!
- Index(es):
Relevant Pages
|
