[Solved] Simple formula in IF = SOLVED

Discuss the spreadsheet application
Post Reply
coachdaniel
Posts: 2
Joined: Mon Apr 26, 2021 8:52 pm

[Solved] Simple formula in IF = SOLVED

Post by coachdaniel »

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
User avatar
floris v
Volunteer
Posts: 4430
Joined: Wed Nov 28, 2007 1:21 pm
Location: Netherlands

Re: Simple formula in IF

Post by floris v »

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
coachdaniel
Posts: 2
Joined: Mon Apr 26, 2021 8:52 pm

Re: Simple formula in IF

Post by coachdaniel »

Got it... THANKS
OpenOffice 3.1 on Windows Vista
Post Reply