ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Having trouble with function. (https://www.excelbanter.com/excel-worksheet-functions/136783-having-trouble-function.html)

Not sure what's wrong

Having trouble with function.
 
I am trying to keep track of the aerial photographs we have on file and also
to easily determine if the Site we have is within an aerial photograph we
have on file. The function is below. (I can't seem to find how to attach the
file...) It sometimes gives me the right answer and sometimes doesn't.

Thank you for your help!

=IF((AND((D4-11.5*B4)<$H$4<(D4+11.5*B4),(E4-11.5*B4)<$I$4<(E4+11.5*B4))),A4,"Do Not Have")


All times are GMT +1. The time now is 07:08 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com