var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: MS Excell - Nested If issue -Amateur
I am looking for a solution for nested If's
My formulae is working, but does not assign the right values..
I am working with cells containing Zip Codes of different countries.
I have a more detailed zip codes metrics for France, Germany and UK with more defined zones.
I dont want to filter out any countries while conditioning the 3 countries and their zip codes, so should I have Spain among Germany, formulae should avoid Spain Zip Code//
Well the best I could come up with is : the zip code has to fit the ranges, if it doesnt - return the value:
=IF(AND($I3>=$C$3,I3<=$D$19),"FRANCE I",IF(AND(I3>=$C$20,I3<=$D$37),"FRANCE II",IF(AND(I3>=$C$39,I3<=$D$142),"UK I",IF(AND(I3>=$C$143,I3<=$D$160),"UK II",IF(AND(I3>=$C$161,I3<=$D$167),"GERMANY I",IF(AND(I3>=$C$168,I3<=$D$175),"GERMANY II",H3))))))
But, I have Lithuania being returned as UK I which is incorrect...Lithuania zip code LV-4100 does not fit into the metrics so it should have been returned.
( i cant attach xls file so i have pasted the metrics in the word..)
The problem here must be with the formats of Zip codes I am working with? Any ideas?
Last edited by Simplify; 10-05-09 at
I have had better luck with uploading the sample of the worksheet, this may help?
Solved the issue
I have solved the problem by going around it..not super happy, bt it works.