formula read

Can someone please explain to me if this formula is saying. It is so big that I don't even to what its saying. I do have a separate worksheet called Customer Cost Calculations, It also reading the data from that work sheet.

=SubstationUsageData[[#This Row],[Average kWh]]*IF(OR(SubstationUsageData[[#This Row],[Revenue Class]]='Customer Cost Calculations'!$B$25,E3='Customer Cost Calculations'!$B$31),VLOOKUP(SubstationUsageData[[#This Row],[Rate Schedule]],'Customer Cost Calculations'!$C$25:$I$35,7,FALSE),VLOOKUP(SubstationUsageData[[#This Row],[Revenue Class]],'Customer Cost Calculations'!$B$4:$I$24,8,FALSE))

Thank you

Take the Average kWH and multiply it by:

Please Login or Register  to view this content.

If Revenue Class is equal to whatever is in cell B25 on the Customer Cost Calculations sheet or is whatever is in cell E3 is equal to cell B31 in the Customer Cost Calculations sheet then

Please Login or Register  to view this content.

look up the Rate Schedule in cells C25 - C35 on the Customer Cost Calculations sheet and find the value in column I of that row

Please Login or Register  to view this content.

Otherwise look up the Revenue Class in cells B4 – B24 of the Customer Cost Calculations sheet and find the value in column I of that row

Please Login or Register  to view this content.

what does the [#This Row] do or means?

This page from Microsoft explains the different portions of a formula created within a table, & about 1/2way down is the explanation of [#This Row]

So I did - sorry!
https://support.office.com/en-us/art...3-c8ae6d2b276e