Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Fri, 03 May 2024 12:38:47 +0000
Post From: spreadsheet copy down without reference auto-correcting itself
| [2017-07-21 08:25:11] |
| traderacademie - Posts: 38 |
|
Hi, I am using the spreadsheet with formulas with referenced cells e.g.: =IF(9<ID2.SG1@3<19,1,0) Then, I use the "copy down" feature to copy the this formula to an adjacent cell and the formula changes to: =IF(9<ID2.SG1@4<19,1,0) So, the reference automatically updates itself. Now this is handy in some cases, but in my case I just want to copy the exact formula without auto update. Is this possible? If yes, could you tell me how? Thanks Rgds Will |