| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Having trouble with function.
I haven't tested, but I think, it should work
=IF((AND((D4-11.5*B4)<$H$4,$H$4<(D4+11.5*B4),(E4-11.5*B4)<$I$4,$I$4<(E4+11.5*B4))),A4,"Do Not Have") "Not sure what's wrong" wrote: 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") |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Having trouble with function.
Thanks Teethless Mama, worked like a charm!
"Teethless mama" wrote: I haven't tested, but I think, it should work =IF((AND((D4-11.5*B4)<$H$4,$H$4<(D4+11.5*B4),(E4-11.5*B4)<$I$4,$I$4<(E4+11.5*B4))),A4,"Do Not Have") "Not sure what's wrong" wrote: 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") |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Having trouble with AVG Function | Excel Worksheet Functions | |||
| Having trouble finding the right function | New Users to Excel | |||
| Offset Function Trouble, Please Help | Excel Worksheet Functions | |||
| IF function trouble | Excel Worksheet Functions | |||
| help please - trouble with sumproduct function | Excel Worksheet Functions | |||
Linear Mode
