Forum Discussion
Looking for an excel Formula
I have a spread sheet where I am tracking my sales vs. my budget. My weekly budget is the same all month, so I need to have the cell calculate the following. Week 2 is Cell G10 minus I26*2 then div...
Thank you for the help.
The jump is the way the sheet is laid out. Reads like a book left to right top to bottom. Has up to 5 weeks. Very simple, but it works for my needs.
The jump is the way the sheet is laid out. Reads like a book left to right top to bottom. Has up to 5 weeks. Very simple, but it works for my needs.
=OFFSET($G$10,(COLUMN(K1)-COLUMN($K$1))*11,(COLUMN(B1)-COLUMN($B$1))*(-2))/$I$26*COLUMN(B1)-1Does this formula return the intended results? The formula is in cell J26 and filled to the right.
