Support Board

• Support Board |
• Search Board |
• Control Panel |
• View My Posts / Threads |
• Direct Messages

Date/Time: Sun, 22 Feb 2026 20:57:21 +0000

Post From: Double Cloud overlap question

[2024-08-31 14:44:18] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 4313
when i do this, see attachment for a screenshot of the errors I get. There are no #SYNTAX? errors so your formulas look good, assuming ID12 and ID13 are the fast cloud, and ID14 and ID17 are the slow cloud. Something else is wrong. See this for possibly why: Working with Spreadsheets: Spreadsheet Errors So that the slow cloud is behind the fast cloud, formulas in L3/M3 and N3/O3 need to be swapped: L3 =IF(K3=1,ID14.SG1@3,0) M3 =IF(K3=1,ID17.SG1@3,0) N3 =IF(K3=1,ID12.SG1@3,0) O3 =IF(K3=1,ID13.SG1@3,0) This works for me. See attached pic. Date Time Of Last Edit: 2024-08-31 21:38:22
0x Thank you
2 Clouds.PNG / V - Attached On 2024-08-31 21:38:17 UTC - Size: 19.29 KB - 108 views