Need assistance for a formula

Hi,

being a "nitwit" when it comes to math and formulas I need assistance with an Excel formula.

• Cell D43 is a sum.
• Depending on its vealue I want to display different texts in cell B44.
• I have three texts divided over cell B46 - C46 - D46
• If the sum in cell D43<=12, I want cell D43 showing the text of cell B46
  If the sum in cell D43 >12 and <=19, I want cell D43 showing the text of cell C46
  If the sum in cell D43=>20, I want cell D43 showing the text of cell D46.
  
  

I asked ChatGPT that came with different answers that made Excel coming with an errorr message:

"A problem was found with this formula.

Don't want to type a formula?
In Excel, if the first character is an equal sign (=) or minus sign (-), it is considered a formula:

- If you type this: =1+1, it will be displayed in the cell as: 2

You can solve this by typing an apostrophe ( ' ) first:

- If you type: '=1+1, this will be displayed in the cell as: =1+1".

Below the ChatGPT answers:

=IF(D43<=12,B46,IF(D43<=19,C46,D46))

=IF(D43<=12,B46,IF(AND(D43>12,D43<=19),C46,D46))

=IF(D43<=12,"Text in B46",IF(AND(D43>12,D43<=19),"Text in C46","Text in D46"))

=IF(D43<=12," Your child's asthma may be very poorly controlled. Please contact your child's healthcare provider right away. "&"Still: no matter what your child's score is, there may be more you and your child's healthcare provider could do to help control your child's asthma symptoms.",IF(AND(D43>12,D43<=19)," Your child's asthma may not be well controlled. Please contact your child's healthcare provider. "&"Because, no matter what your child's score is, there may be more you and your child's healthcare provider could do to help control your child's asthma symptoms."," Your child's asthma may be well controlled. Please stay in contact with your child's healthcare provider. "&"Because, no matter what your child's score is, there may be more you and your child's healthcare provider could do to help control your child's asthma symptoms even better."))

Perhaps somebody could help me with this. I'd be very happy with it. 🙂

Kornelis Jan