Hi,
I am looking for a formula that help to auto-fill an emty cell (in a range) with value to make total sum equal a given number.
Say a1=2, b1=4, c1=6, what formula do to find value of d1 to make the total e1=sum(a1:d1)=15
I know it may sound silly but I really need help. thks.