String Matching Error

Hey Gang,

I am having a bit of a problem with a script.

=IF(EXACT('Costing Worksheet'!L3, "Closed"), J3=0, ABS((TODAY())-B3))

What I am trying to accomplish is for the script to look at a cell ('Costing Worksheet'!L3), and in this cell is a drop down list, and if the list choice reads "Closed" I want the value "0" to populate cell J3 (The cell where the script resides) and if not I want it populated with the result of the calculation Today() - B3. For some reason I am getting a Circular Reference error, although I don't know why because I am not trying to pull any info from the originating cell (J3) just trying to populate it if the drop down list has "Closed" chosen. Is there another way to make sure "0" is printed to the originating cell in this case?

Thanks,
Straywire

Thanks @FDibbins, I had to modify the "0" to "J3 = 0", for some reason it was just returning the value "TRUE"

I am a Project Manager and am creating a spreadsheet for Costing Analysis and this script will check the status of each line item and return a value for the dashboard that will allow me determine "days in the system" based on whether or not the line item is still open or has been closed. This value will then be used to create 2 separate charts, one for open costing items and one for closed items.

I will no doubt be hanging out here more since my VBA is a little rough, I just started this position, and I will be creating a lot of spreadsheets.

Thanks again!