Hello, I am having trouble with simple IF conditions.
IF
Cell1 < 10
Cell1 >-10
Cell2 <10
Cell2 > -10
Cell3 <10
Cell3 >-13
if true then U
If false then X
Tried commas and semi colons between conditions but not working..
Is is possible that due to cell numbers being generated from formulas is affecting it?
thanks in advance for any help
[Solved] Simple formula in IF = SOLVED
-
- Posts: 2
- Joined: Mon Apr 26, 2021 8:52 pm
[Solved] Simple formula in IF = SOLVED
Last edited by floris v on Mon Apr 26, 2021 9:18 pm, edited 2 times in total.
Reason: Tagged as Solved as per OP's reply, floris v, moderator
Reason: Tagged as Solved as per OP's reply, floris v, moderator
OpenOffice 3.1 on Windows Vista
Re: Simple formula in IF
Enter =if(And(A1 > 10;A1 <20);12;24). So, If, And, Or and the like aren't operators as in BASIC or other programming languages, but functions taking parameters.
OpenOffice 4.1.11 on Ubuntu; LibreOffice 6.4 on Linux Mint, LibreOffice 7.6.2.1 on Ubuntu
If your problem has been solved or your question has been answered, please edit the first post in this thread and add [Solved] to the title bar.
Nederlandstalig forum
If your problem has been solved or your question has been answered, please edit the first post in this thread and add [Solved] to the title bar.
Nederlandstalig forum
-
- Posts: 2
- Joined: Mon Apr 26, 2021 8:52 pm