I need help with these formulas, i have an assignment to find out what they do but maybe i don't get it. here is the formulas and what i think they do. But it is hard for me to know that they are meant to do i do not understand the RC and C ?
VLOOKUP(RC[3],Sheet1!C[-1]:C[3],4,FALSE)*(RC[1]/SUMIF(C[3],RC[3],C[1]))
=IF(RC[1]>0,(RC[1]/SUMIF(C[-2],RC[-2],C[1]))*SUMIF(C[-2],RC[-2],C[-1]),0)
=SUMIF(Utdata!C,RC[-4],Sheet2!C[-2])/SUM(Sheet2!C[-2])
Bookmarks