Support Board
Date/Time: Sun, 08 Jun 2025 00:25:26 +0000
Post From: Spreadsheet formula efficiency
| [2023-02-16 13:51:43] |
| User247273 - Posts: 39 |
|
I realize this might be a dumb question, but is it possible to tell me which of these two formulas below is the most efficient way to get my answer? I have several columns across several sheets with similar types of evaluations so I'm trying to make sure I minimize the demand on my CPU as much as possible. If there's a help page related to this, can you point me in that direction as well. I got a little turned around in my research. Option A: =IF(AND(O3=1,P3=1,Q3=1,R=1,S3=1),1,0) Option B: =IF(SUM(O3:S3)=5,1,0) I'm constructing a spreadsheet system for trading and it looks like I'll need this type of evaluation in about 21000 cells (7 columns * 6 sheets * 500 rows). Even though I'm only evaluating once per bar, I'd like to get the sheets to calculate as fast as possible. |