Cashbook error

[ozbeachbum]

I am setting up a cash book for the treasurer of our club and have a issue with the following formula.
=IF(SUM(I18:AB18)=0,"Auto Calculation",IF(AND(I18>0,SUM(J18:AB18))<>I18,"Error",SUM(J18:AB18)))
II8 is $460 J18:AB18 is $460 the formula is returning "Error" where I need it to SUM(J18:AB18) = $460
I have tried different bracketing to no avail.
Any assistance would be greatly appreciated.
Cheers,
Dave.

 

[Alex Blakenburg]

Just move the 2nd bracket you have before <> to be after <>I18, see below:

=IF(SUM(I18:AB18)=0,
     "Auto Calculation",
      IF(AND(I18>0,SUM(J18:AB18)<>I18),
                  "Error",
                   SUM(J18:AB18)))

 

[ozbeachbum]

Just move the 2nd bracket you have before <> to be after <>I18, see below:

=IF(SUM(I18:AB18)=0,
     "Auto Calculation",
      IF(AND(I18>0,SUM(J18:AB18)<>I18),
                  "Error",
                   SUM(J18:AB18)))

Thank you so much.
Cheers,
Dave.

 

[Alex Blakenburg]

No problem. Glad I could help.