What is the Proper structure for an "IF" statement ?

General discussion on OpenOffice Calc and its spreadsheets.

What is the Proper structure for an "IF" statement ?

Postby Jill R. Lipe » Mon Jul 07, 2014 8:40 am

Hi,

What is the proper structure for combining an "OR" argument within an "IF" statement? I don't even know if this is the proper
way or if there is another way to do it. I,ve tried a few ways but keep getting errors. Basically i'm trying to incorporate two
test entries within one "IF" statement.

Thanks,
Jill R. Lipe
 
Posts: 33
Joined: Mon Mar 24, 2014 6:30 am

Re: What is the Proper structure for an "IF" statement ?

Postby LiverPAN » Mon Jul 07, 2014 10:59 am

Hello,

To check whether A1 is greater than B1 or C1
Code: Select all
=IF(OR(A1>B1;A1>C1);"Yes it is."; "No it isn't")


Thanks,
LiverPAN
 
Posts: 24
Joined: Tue Mar 25, 2014 6:30 am


Return to OpenOffice.org Calc

Who is online

Users browsing this forum: No registered users and 0 guests

cron