Support Board
Date/Time: Sat, 22 Feb 2025 17:36:36 +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? |