[Solved] Simple formula in IF = SOLVED

[Solved] Simple formula in IF = SOLVED

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
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
OpenOffice 3.1 on Windows Vista
coachdaniel

Posts: 2
Joined: Mon Apr 26, 2021 8:52 pm

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.
AOO 4.1.6 op Linux Mint
Nederlandstalig forum

floris v
Volunteer

Posts: 4250
Joined: Wed Nov 28, 2007 1:21 pm
Location: Netherlands

Re: Simple formula in IF

Got it... THANKS
OpenOffice 3.1 on Windows Vista
coachdaniel

Posts: 2
Joined: Mon Apr 26, 2021 8:52 pm