LinkBack URL
About LinkBacks
For number 1 you would just do something like:
=if((SUM(MD!C5,BI!C8,Mny!C5,Theft!C5,EL!TABLE_29,PL!F5))=0,Nil,SUM(MD!C5,BI!C8,Mny!C5,Theft!C5,EL!TABLE_29,PL!F5))
For number 1 you would just do something like:
=if((SUM(MD!C5,BI!C8,Mny!C5,Theft!C5,EL!TABLE_29,PL!F5))=0,Nil,SUM(MD!C5,BI!C8,Mny!C5,Theft!C5,EL!TABLE_29,PL!F5))
If someone helped give them rep using the star button.
If you have received a satisfactory solution please mark the thread solved. If not Fotis will come for you at night :P
Thank you for help by using this formula the answer is coming #NAME? where I want Nil.
The amount will be "Nil" not a Zero value put in all six sheets.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks