Returning a comment within three columns

[Yusuf]

Hi all

I would like to return a comment "Complete" from data in three columns in a pivot table.
The problem is that not all accounts have the first item

Eg
Col A - Account nos
Col B - Pens
Col C - Pens Collected
Col D - Pencils
Col E - Pencils Collected
Col F - Pencil Boxes
Col G - Pencil Boxes Collected
(You can round the figures off to 1's and 2's if it makes things easier)

The reason I have the number of items first is sothat I can see how many were issued and compare those collected
Also, some of the accounts don't have "Pens" and of course "Pens Collected" so my predicament is that I would like a formula on the right of the table that states;

If B5="" then ignore B & C but return "Acc Closed" if D5=E5 and F5=G5

I am tasked of producing a figure that shows the accounts closed by the accounts issued only if all the criteria are met
I will then count the "Acc Collected" and work a percentage by the total acc's.

PS - If you have any suggestions and other ways that this result is possible then I'll really appreciate it

 

[Harvey]

=IF(AND($B2="", AND($D2=$E2, $F2=$G2)),"acc closed", "open")

this formula will do the thing you requested in you pseudo code

If B5="" then ignore B & C but return "Acc Closed" if D5=E5 and F5=G5

Im not sure what your complete formula would look like. Should it measure B & C too when they are not empty?

 

[BrianB]

How about this :-
=IF(B1-C1+D1-E1+F1-G1=0,"Complete","Not Complete")

 

[Yusuf]

Awesome guys, thanks Very much.

Enjoy your weekend
Cheers
Yusuf