Forum Discussion
XL Ageing Creditor formula help
Hi, I'm in desperate need of some help please as I don't really know much about formulas, so it may be a daft question? I'm trying to create a formula for an aged creditor report however the ones I'...
Martin_Weiss Omg, that's excellent, thank you so much 😄
Shouldn't have spent weeks researching but come on here weeks ago.
Appreciate it, thanks
Peter, I couldn't get yours to work, as it kept coming up with a formula error. I've obviously missed something along the way?
I entered the following, but clearly it's incorrect. What have I done wrong please? Thank you
=IF(@[O20]<@[L20],@[I20]-N9,"")
My guess is that you did not convert the data to a Table (Ctrl/T) or name the cell containing the report date.