Is there any easy way to write a formula which will do the following:
=if(concatenate(a2*b2-c2+d2*e2)="",NA,concatenate(a2*b2-c2+d2*e2))
The reason is if there is complex calculation, then the 'if' statement becomes too long and also changes have to be done at 2 places.
Regards
AK
=if(concatenate(a2*b2-c2+d2*e2)="",NA,concatenate(a2*b2-c2+d2*e2))
The reason is if there is complex calculation, then the 'if' statement becomes too long and also changes have to be done at 2 places.
Regards
AK