Hey everyone,

I am trying to create a formula that can check if its friday and multiply that value times 3 to accrue for the weekend (fri, sat, sun). However its is giving me a circular reference because I have a formula in that cell that grabs the last value of a column in another spreadsheet. Can someone assit me with this?

This is what I have tried so far:

=INDEX('1714'!CN10:CN40, COUNTA('1714'!CN10:CN40),[/B][/B] 1)+IF(F3>4,C3*3,C3) - This gave me the circular reference