Support Board
Date/Time: Sat, 22 Feb 2025 09:34:04 +0000
[User Discussion] - Spreadsheet formula with if and compare values?
View Count: 572
| [2021-01-30 23:34:22] |
| User130862 - Posts: 20 |
|
Hi, Using libreoffice calc and there I can use : if(a1>b2; a1/b2; b2/a1) Meaning if condition true, do calculation of a1/b2, else b2/a1. How can I achieve same with spreadsheet formula? Tried it like this but it displays nothing. =if(ID1.SG10[0]>ID1.SG11[0], ID1.SG10[0]/ID1.SG11[0], ID1.SG11[0]/ID1.SG10) Ideas? |
| [2021-01-31 16:43:11] |
| ForgivingComputers.com - Posts: 1012 |
|
The syntax looks correct. The first thing I would do is verify individual values: =ID1.SG10[0]
=ID1.SG11[0]
Makes sure they are non-zero, or it will try to divide by zero. |
To post a message in this thread, you need to log in with your Sierra Chart account: