Formula decides it dosent want to work!

  • Thread starter Thread starter Bob Vance
  • Start date Start date
B

Bob Vance

=IF(AND(ISNUMBER(Y2),Z2=""),"O.D.",IF(AND(ISNUMBER(Z2),Z2<>0),MAX(S$1:S1)+1,
0))
This formula copies down a number from above +1 if there is a sum in Z2 but
if there is only a sum in Y2 it shows O.D. now after 2 years and 24 copy
overs to the next month if refuses to show O.D. I have tried everything the
formula is the same as the month before excepting the Column letter from
coping over #Confused#
--
Thanks in advance for your help....Bob Vance
..
..
..
..
 
Hi Bob
two ideas:
- have you checked that Z2 is empty. deleting this cell does not change
the result?
- Is you calculation mode set to manual?

Frank
 
YES when I deleted Z2 the O.D came up but both Y2 and Z2 have formulas in
them?
How do I check the calculation mode I clicked f9 no difference

--
Thanks in advance for your help....Bob Vance
..
..
..
..
 
Sorry, Tools > options> automatic is checked

--
Thanks in advance for your help....Bob Vance
..
..
..
..
 
Changed the ="" to <1 and that seem to work what do you think?

--
Thanks in advance for your help....Bob Vance
..
..
..
..
 
Actually changed it to <0.1 can you see any pit falls apart from if there 9c
owing?

--
Thanks in advance for your help....Bob Vance
..
..
..
..
 
Hi Bob
some ideas:
1. can you post your actual formula in Z2. Seems to return something
else but not ""
2. Another way: Check the conten of Z2. e.g. try =CODE(Z2) what does
this return

Frank
 
Formula in Z2 is =X129 which is a number

--
Thanks in advance for your help....Bob Vance
..
..
..
..
 
Hi Bob
but then the result not showing 'OD' is o.k. as Z2 is not ="" or am I
missing something here?

Frank
 
Changed Z2 from ="" to <0.01 then I get the OD

--
Thanks in advance for your help....Bob Vance
..
..
..
..
 
Back
Top