Prev: Sort Question
Next: Spreedsheet for Transfer of Undertakings Employee Information
From: Paul on 4 May 2010 11:38
Anybody know how to write a formula for a statement involving "if" and "or"
statements such as:

if (cell x=? and (cell y=? or cell z=?)) then cell Q=? or blank
From: Tom Hutchins on 4 May 2010 11:51
In general terms:
=IF(AND(X=?,OR(Y=?,Z=?)),?,"")
This formula would have to be in cell Q

An example with actual cells:
=IF(AND(A1=10,OR(A2=15,A3=20)),100,"")
This formula must be in the cell to which the result should be returned. A
formula can't "reach out" and put a value in another cell; it just returns a
value to the cell that has the formula.

Please note that a formula can return an empty string "" which makes it
appear empty, but it is not actually blank (it contains the formula).

Hope this helps,

Hutch

"Paul" wrote:

> Anybody know how to write a formula for a statement involving "if" and "or"
> statements such as:
>
> if (cell x=? and (cell y=? or cell z=?)) then cell Q=? or blank
From: trip_to_tokyo on 4 May 2010 11:53
EXCEL 2007

Here is the syntax you require:-

=IF(OR(D5="Finance",D5="Training"),100,20)

You need to adpat the above to your needs.

The above says that if cell D5 is Finance or Training then 100 otherwise 20.

If my comments have helped please hit Yes.

Thanks.



"Paul" wrote:

> Anybody know how to write a formula for a statement involving "if" and "or"
> statements such as:
>
> if (cell x=? and (cell y=? or cell z=?)) then cell Q=? or blank
From: Pete_UK on 4 May 2010 11:54
Try this:

=IF(AND(A1=1,OR(A2=2,A3=3)),"Q","")

Next time give proper cell references rather than "cell x".

Hope this helps.

Pete

On May 4, 4:38 pm, Paul <P...(a)discussions.microsoft.com> wrote:
> Anybody know how to write a formula for a statement involving "if" and "or"
> statements such as:
>
> if (cell x=? and (cell y=? or cell z=?)) then cell Q=? or blank

From: Luke M on 4 May 2010 12:08
Example formula:

=IF(AND(A1=2,OR(A2=3,A3=3)),TRUE,FALSE)

The OR and AND function contain their arguements.
--
Best Regards,

Luke M
"Paul" <Paul(a)discussions.microsoft.com> wrote in message
news:DB73F7E6-CD77-4CF8-B121-1D5DC6DA93B3(a)microsoft.com...
> Anybody know how to write a formula for a statement involving "if" and
> "or"
> statements such as:
>
> if (cell x=? and (cell y=? or cell z=?)) then cell Q=? or blank


 | 
Pages: 1
Prev: Sort Question
Next: Spreedsheet for Transfer of Undertakings Employee Information