additional criteria for if formula

[2001jesper]

Hi...

Im using an if to find cells based on a criteria. this works fine for the outterbounds (ex 1 and 10), but when i need to find a number that a based on two criterias i cant make it work.

Is it possile to add an "and" to the line or how can i make this easy

Please Login or Register  to view this content.

all input will be appriciated..

thx in advance

[GIS2013]

Hi. I've randomally populated a range, and happened that both e3 and j6 are equal to 88, then I added a second criteria (using AND) and it seems like your code is working..

Please Login or Register  to view this content.

[2001jesper]

Thx mate, it worked perfectly!

[GIS2013]

Glad I could assist