Ok, let me try and explain myself again,
You see cell b1, and all of line 17, they are related, so everything i type in cell b1, i want it to be updated on line 17.
so pretty much the math i want to be done is, c17=(b1+c15), d17=(c17+d15), e17=(d17+e15), all across line 17. the problem i ran into is
that with the if function, if there is nothing on column C, then from column D and beyond it will return a #value. so i want to be able to do that simple math, while having that if function (which makes it so that if there is no value on that column it will return blank instead of $0.00).
Thanks.
Bookmarks