Circular Reference - Formula using the weekend

[robert137]

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

[Cutter]

Hello robert137, and welcome to the forum.

Unfortunately you have inadvertently broken one of the forum rules. Please read the following. Thanks.

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.