Support Board

Date/Time: Mon, 16 Sep 2024 19:41:47 +0000

Post From: Receiving "#REF!" Error in spreadsheet

[2024-07-17 21:16:10] Link To Thread - Link To Post [Go To First Post]
User43 - Posts: 101
Then it looks like the statement created using the indirect function leads to a REF error. Personally I don't like to use the indirect function. Couldn't you achieve the same by using a offset? if your JJ3 field for some reason puts out some kind of error, or no number at all, you would end up with a REF error. Maybe consider putting a fail save into the indirect call by checking before using it if JJ3 is a number. Date Time Of Last Edit: 2024-07-17 21:41:24