PLease help me with formula's

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Pleaes help me to compare the current Month vs. Average (Cell AD). I thought I
=AVERAGE(IF($R$11:$AC$11<=S2,$R$14:$AC$14))-AD14 (Not working)
2). I would also like to have a formula to do the Delta % from Current
But that is not working either. The original formula I was using is
Click to expand...
=1-(AC14/AD14) but that would mean I have to manually change this as well.
Wasn't wanting to do that...

Thanks. :)
 
Not working means I am unable to populate a formula that will change my
current month cell vs. average cell when changing from month to month without
manually having to enter in a formula for each month. I was hoping to have a
formula automatically populate information like I had done so with the
average cell (see beginning of this message). I did try to array the formula
but it is not working, I do not get the right number.

As for my 2nd question with Delta, same response above as to not working.
Does this make sense?
Thanks,
--
Beth


Don Guillett said:
Not working means?
Did you array enter the array formula?
Click to expand...
 
Back
Top