Forum Discussion

kjdnl's avatar
kjdnl
Copper Contributor
Feb 14, 2023
Solved

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...
Formulas and Functions
kjdnl's avatar
kjdnl
Copper Contributor
Feb 15, 2023

SergeiBaklan 

 

Hi Sergei and thank you for your help!

Unfortunately Excel comes with the same error message.

So, there's a big chance this is due to my non-present expertise concerning formulas. For this reason I made a copy of the sheet, hoping if you could have a look at it. You will find the sheet https://docs.google.com/spreadsheets/d/1SnbJtw3Ofj6Z9Aqy52Uysm3nScmX2zy4/edit?usp=sharing&ouid=104110264675344286977&rtpof=true&sd=true. Feel free to make any changes you want.

 

Know that, if it takes too much time, I'd definitely understand. But if you want to give it a try, I'd be pretty happy.

 

Thanks, Kornelis Jan

  • kjdnl's avatar
    kjdnl
    Copper Contributor
    Feb 15, 2023
    Hi Sergei,

    thanks again for helping out!

    Since you didn't run into the issue I opened the file again to see if I still would experience the problem and I was completely astonished by the fact that now it works.

    I can't explain this and I apologize for having bothered you with this. Hope it didn't take much of your time.

    Best regards,
    Kornelis Jan
    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Feb 15, 2023

      kjdnl 

      No problems, main point it works for you.