KoolAsIce
asked on
Meaning of excel formula
Can someone please tell me the what the formula attached as image is doing? Especially, I need to know what Table4 is doing here?
Any help will be highly appreciated.
thanks
excel-question-2.PNG
Any help will be highly appreciated.
thanks
excel-question-2.PNG
ASKER
hi Teylyn,
Thank you so much for your reply. I did try that, but that didn't change anything.
Could you possibly make any sense of these formulas just by looking at them? If you do please let me know.
Thank you so much for your help.
Thank you so much for your reply. I did try that, but that didn't change anything.
Could you possibly make any sense of these formulas just by looking at them? If you do please let me know.
Thank you so much for your help.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
these formulas use a reference to a table that has been created with Insert > Table.
You can toggle back to normal referencing with a setting in the Excel Options. In 2010 it is
File > Options > Formulas > Use table names in formulas
Untick that and the familiar cell references will be displayed in the formulas.
cheers, teylyn