Support Board
Date/Time: Mon, 03 Nov 2025 15:33:29 +0000
Post From: Spreadsheet formula with if and compare values?
| [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? |