[Solved] Simple formula in IF = SOLVED

Discuss the spreadsheet application

[Solved] Simple formula in IF = SOLVED

Postby coachdaniel » Mon Apr 26, 2021 9:01 pm

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

Postby floris v » Mon Apr 26, 2021 9:13 pm

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

Re: Simple formula in IF

Postby coachdaniel » Mon Apr 26, 2021 9:16 pm

Got it... THANKS
OpenOffice 3.1 on Windows Vista
coachdaniel
 
Posts: 2
Joined: Mon Apr 26, 2021 8:52 pm


Return to Calc

Who is online

Users browsing this forum: No registered users and 15 guests