[Solved] If this then that issue

[hacketm]

Hi, I`m trying to get a formula correct.

What i`m trying to do is, if (O3=false then Y3= -1.5 * N3), If O3=True, Then Y3 =.60
Am I far off with =IF(O3="False");Y3=(1.5*N3),;If(O3="True");Y3,.60))

Thank you in advance.

[RoryOF]

You should only need one IF statement; the syntax is IF(Test;Then _value;Otherwise_value)

[hacketm]

Even with the second "if" out I`m getting a 508 error

[RoryOF]

in Calc Help look up ### error message (hint: missing bracket)

[hacketm]

Am I far off with the following

=IF(O3="False");Y3=(-1.5*N3),;(O3="True");Y3,.60)))

[RoryOF]

Count your start and your closing brackets. You want to do this - you have to learn to write the expression.

[Lupp]

Did you ever read anything about using Calc (or any spreadsheet software)?

You cannot assign results to arbitrary cells by formulae. If you want to assign the result to cell Y3, you need to put the formula into cell Y3. Boolean values are simply used as test results. You don't need to compare them with anything. If O3 is Boolean (logical) and gives a test result, using it in the place of the condition in the IF() function, automatically applies the else-case if the condition came out FALSE.

Code: Select all

=IF(O3;0.60;1.5*N3)

placed in Y3 should be appropriate.

[hacketm]

I`m new to all of this, That worked, Thank you for the help

[robleyd]

If you are new to spreadsheets you may find the following links helpful:

[Tutorial] Ten concepts that every Calc user should know

OpenOffice Spreadsheet Tutorial for Beginners with Examples

[Tutorial] Absolute, relative and mixed references