#value!

**kivikatz** · 01-31-2023, 03:13 AM

Hi All. I recently posted this issue on Mr. Excel, but got no response, so I would like to post it here to see if anyone can help.

I have an issue that is cropping up with the formula (see attached workbook). When I close the spreadsheet and open it up again, I get #VALUE! errors in all the cells that use the formula. If I manually click into either Cell 1A/1B and either 4A/4B and press enter, it fixes the issues. This error crops up whether the cells in column A/B are blank, contain numbers or has text. I also formatted the cell as numbers. Not sure what is happening, but appreciate any help. Thanks.

Crossposted here: https://www.mrexcel.com/board/thread.../#post-6010208

**Glenn Kennedy** · 01-31-2023, 06:50 AM

If you are actually using Excel 2019, it will not work as the LET function is not availabale in Excel 2019.

I assume you were sent the file by someone who DOES have Excel 2021 or O365.

**Glenn Kennedy** · 01-31-2023, 06:56 AM

Next time, please provise the LINK to the cross-post. I've done it this time.

**ExcelKat** · 01-31-2023, 10:29 AM

Thanks. Guess I’ll have to update Microsoft Office to get that functionality.

**ExcelKat** · 01-31-2023, 10:31 AM

Thanks for the advice. I’ll keep that in mind should I ever need to repost. This was the first time I reposted. Sorry for the oversight.

**Glenn Kennedy** · 01-31-2023, 11:09 AM

Are you in USA... or Thailand??

If you can explain (in words) what you WANT the formula to do, I can see if I can fins an Excel 2019-friendly way to do it....

But, if you're going to upgrade...

You're welcome.

It would be very nice if you were to just click the Add Reputation button at the foot of any of the posts of members who helped you reach a solution.

Finally, if that takes care of your original question, please click on "Thread Tools" from the menu link (just above the first post in the thread) and mark this thread as SOLVED.