if between function

[samuel_brierley]

Hi all,

i have the following expression but want to change is slightly so it incorporates some kind of between funciton

=IF(Latitude > Lat1 AND Latitude < Lat2 AND Longitude > Long1 AND Longitude < Long2, Area,'')

thanks all

[Kushal_Chawda]

if you can share some sample data then I don't think so It is not possible because people here are very intelligent

[samuel_brierley]

please find the attached data,

you will notice in the data that the AQMA table is actually called Sheet1.

thanks for all the help and if you do manage it can you please post the script as im only a personal user.

thanks