I am trying to make a bidding assistant. Need some help

[Stumpped]

My formula so far is: =iferror(MIN(IF((D225:D232=D224)*(E225:E232=E224)*(C225:C232="Declined")*(I225:I232<>""), I225:I232)), "XX") and it is an array formula.

I've also tried: =IFERROR(MIN(IF((D225:D232 & E225:E232 = D224 & E224) * (C225:C232 = "Declined") * (I225:I232 <> ""), I225:I232)), "XX"), also an array formula
and =IFERROR(MIN(IF((D225:D232 & "|" & E225:E232 = D224 & "|" & E224) * (C225:C232 = "Declined") * (I225:I232 <> ""), I225:I232)), "XX")

What I am trying to achieve is to check the value in cells D224 and E224. Then match that with rows in cells D225:D1200 and E225:E1200, then check the corresponding row C225:C1200.
Then I am trying to find the minimum value of the corresponding $values in cells I225:I1200. Currently, I have rows 225:232 populated, but over time this list will grow. The intent is to find the client name (Column E). Then the assignment is typed in (Column D) then The status"Declined" in Column C then find all the bid amounts located in Column I that match all these criteria.

So far I've asked several different AI chatbots to help and so far all the formulas come up with an Err:508 error. I am using Apache Open Office 4.1.7.

There are quite a few more renditions of the formula I have tried, all with the Err:508 error.

The idea is that it finds the low bid amount for the client and the assignment type, and if it's declined, then I must keep bidding lower until I find the point where that client accepts jobs.
On the other hand, when a job is "Accepted" in column C, then it would do the same checks but instead of finding the low value, it finds the high value of the "Accepted" jobs.

 

[Logit]

I'll not be able to assist you, however ... when you say : " I am using Apache Open Office 4.1.7." Did you instruct the AI chatbot you were using
that software ?

 

[Stumpped]

Yes, I did. The chatbot I am using, AI Chat on the tab but the website is AI Chat - DeepAI. Anyway, I was working with some other formulas and it uses semi-colons in its formulas instead of commas in some instances I've come to find out. I have solved the issue, I peeled the potato from a different angle so to speak. Instead of trying to get the numbers from a single formula I built a grid, did some comparisons, and then did the MIN and the MAX for each and now everything is groovy!

 

[Logit]

It would be great to post your solution for others to learn from. Cheers !

 

[Stumpped]

So, the top row in this instance was to put in the assignment type and client name in cells D224 & E224.
Below are the lines I have been adding, Row 225 is now a place holder because when I insert a line, the formulas to check the data need to function.
off to the screen on the right, somewhere around cell AA224, I have the formula to concatenate the assignment type and client.
Then each line below also has the client name and assignment type concatenated on the row they are located in, i.e. = D226 & " " & E226
Then to the left, in column Q, I have the formula =IF(AND($R$223=R226; C226="Declined"); I226; ""). This gives me the bid amounts for all declined jobs from a certain client for a certain type of assignment.
Then to the right of Column R, in column S, I have the formula =IF(AND($R$223=R226; C226="Accepted"); I226; ""). This gives me the bid amounts for all accepted jobs from a certain client for a certain type of assignment.
Then I have two other formulas, one to check the high amount for the accepted jobs from a certain client for a certain job and shows the high number with the formula: =MAX(S226:S233)
The second formula shows me the low amount from all the bids that were declined, =MIN(Q224:Q233) so when I decide to make a bit, I can incrementally lower my fees for certain clients until I find the price point where I have accepted jobs. It's not always going to be like this. But for now since business is slow, this is what I must do to survive.
I'm sure there is a formula out there that was going to work, but I got tired of taking so much time trying to figure it out all in a single formula or two.

Sorry if my explanation is a bit messy. I am not a programmer, I am an appraiser by trade but use excel to quite an extent for my purposes.

Hope that helps. I'm marking this as answered although there was no response and a solution to the single formula question as I found a workaround.