Support Board
Date/Time: Sun, 24 Nov 2024 01:12:03 +0000
Post From: Receiving "#REF!" Error in spreadsheet
| [2024-07-17 21:16:10] |
| 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
|