If cell is MT, then value coming ERROR

Hi friends,

I have below formula in my worksheet, If any one cell not contain any value, then formula getting error like

Please Login or Register  to view this content.

any suggestions.

Eg : If I have any MT cells in CG7, CI7, CK7, CS7, CU7, CW7, CY7; then formula answer getting error.

Actually I want : If any cell is MT, then value can be 0 and total formula will work.

You could put this in at the beginning... IF(OR(CG7,CI7,CK7,CS7,CU7,CW7,CY7)="MT",0,then the remainder of your formula.

It would be better if there was a sample file on which to test possible solutions. To upload a sample select the GO ADVANCED button and scroll down to MANAGE ATTACHMENTS (the paperclip icon doesn't work).
That said and though it is a bit on the tedious side, but it seems you could preface each addend segment with an IF function so that if the lookup value isn't blank it will preform the vlookup and if the lookup value is blank that addend segment will evaluate to zero as in:

Formula:

Please Login or Register  to view this content.

Let us know if you have any questions.

You're Welcome. Thank You for the feedback and for marking the thread as solved. I hope that you have a blessed day.