Forum Discussion
Solved
Help needed to link IF functions into 1 cell
Hi All, I have a tracker spreadsheet that upon entering dates into cells, there is a calendar section at the end where the dates populate into there in the forms of numbers - which are then conditi...
That is what I sort of thought and mentioned in my reply all you have to do is remove that last line of the equation:
=ROUND(IFERROR( (--L$3>$A$4)* XMATCH(K$3,HSTACK($A$4,$B$4,$C$4,$D$4,$E$4,$F$4,$G$4,$H$4,$I$4,$J$4),1),0)/2,0)This should return the 0,1,2,3,4,5 all on the same row
