Changing if then statments into an array

[GoonSqd]

hey there, im trying to change a co-workers if statements into an array if possible
im trying to validate that If Colum AA is 1 or greater then to check if Colum AQ is between 7.3 and 8.3 and if its anything else to check Colum y and if there is a date then colum AQ should be zero, if there isnt then check colum x and make that the value for colum AQ

 

[hajiali]

Which cell is the formula applied to? Seems like you need it in AQ however it seems like your also checking cell value of AQ in the same formula. Which I don’t think is possible. Please clarify

 

[Peter_SSs]

Duplicate to: HOW TO MAKE IF STATMENTS INTO ARRAYS

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread since the other one has more replies so please continue in the linked thread.