Page 1 of 1

[Solved] Simple formula in IF = SOLVED

PostPosted: Mon Apr 26, 2021 9:01 pm
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

Re: Simple formula in IF

PostPosted: Mon Apr 26, 2021 9:13 pm
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.

Re: Simple formula in IF

PostPosted: Mon Apr 26, 2021 9:16 pm
by coachdaniel
Got it... THANKS