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
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Feb 14, 2023

kjdnl 

Please try

=IF(D43<=12,B46,IF(D43<=19,C46,D46) )
  • 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