If your Excel 2024 is not calculating the formula =image(concat("https://logo.clearbit.com/",cellnum,".com")), there are a few things you can check:
- Check Calculation Options: Ensure that Excel is set to automatically calculate formulas. You can do this by going to File > Options > Formulas and checking that Automatic is selected under Calculation options.
- Cell Reference: Make sure that
cellnumis defined correctly in your worksheet. Ifcellnumis a named range or refers to a specific cell, ensure that it contains valid data. - Formula Syntax: Verify that the syntax of your formula is correct. The
CONCATfunction should concatenate the string correctly. You might want to test theCONCATpart separately to see if it returns the expected URL. - Excel Version Compatibility: Since you mentioned using Excel 2024, ensure that the functions you are using are supported in this version. Sometimes, newer functions may behave differently or require updates.
- Check for Errors: If there are any errors in the cells referenced by your formula, it may prevent the formula from calculating correctly. Look for any
#VALUE!or other error messages in the related cells. - Recalculate Workbook: You can force Excel to recalculate all open workbooks by pressing
CTRL + ALT + F9.
If these steps do not resolve the issue, consider looking for updates for Excel or checking the Microsoft support resources for further assistance.
References: