Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
help in nested if formulas
I keep a series of worksheets for weekly sales results that contain sales
results from Last year and entry points for comparison for sales for this year eg wk 1 Wk2 wk3 Wk4 Period to date Year to date TY LY % Ty LY % Ty Ly % TY Ly % Ty LY % Ty LY % Last years data is already populated from the previous year's sheet automatically. My conumdrum is this. As I enter wk 1 this years sales, then week 2 etc. they compare themselves to the already totalled period sales from LY. I want the data in Period to date to add together as I enter in this years sales. My attempt using IF nested formulas failed..here is what I tried. =IF(B60,SUM(C6)),IF(E60,SUM(C6+F6)) and so on for wks 3 and 4. Unfortunately because the IF value in the first formula is true as well as the second as I enter the data, individually they are correct but the second formula will not overide the first and by default the third (if i continued on for wks 3 and 4) will not overide the second etc. Is there a way to have each formula overide the previous to give a correct accumulated value for last years sales to compare with the current data for this year??? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to Evaluate Dynamic DDE Formulas | Excel Worksheet Functions | |||
How do I use wild cards in nested array formulas? | Excel Worksheet Functions | |||
Array Formulas take waaaay too long... | Excel Worksheet Functions | |||
locking formulas?? | Excel Discussion (Misc queries) | |||
Need Formulas for counting multiple conditions | Excel Worksheet Functions |