Why not post your formula ( or part of it ) so we can see what seems to be the problem ?
@Steve
As the OP's profile indicates he is using XL 2019 the LET function is not available (and your profile states the same?)

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post