If/And/Or formula

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jmv - 20 Jun 2006 21:35 GMT

I need a formula for the below:

if a1 is greater than zero or a2 is greater than zero and a3 is zero
then "footnote A"

I have been trying If formulas with And and I can not seem to figur
this out - I would appreciate all help. - Thank you

Reply to this Message

Toppers - 20 Jun 2006 21:45 GMT

=IF(AND(OR(A1>0,A2>0,),A3=0),"footnote a","")

> I need a formula for the below:
>
[quoted text clipped - 3 lines]
> I have been trying If formulas with And and I can not seem to figure
> this out - I would appreciate all help. - Thank you.

Reply to this Message

Elkar - 20 Jun 2006 21:47 GMT

There are a couple ways to read your question, but one of these formulas
should do the trick:

=IF(AND(OR(A1>0,A2>0),A3=0),"Footnote A","")

=IF(OR(A1>0,AND(A2>0,A3=0)),"Footnote A","")

HTH,
Elkar

> I need a formula for the below:
>
[quoted text clipped - 3 lines]
> I have been trying If formulas with And and I can not seem to figure
> this out - I would appreciate all help. - Thank you.

Reply to this Message

Marcelo - 20 Jun 2006 21:51 GMT

Hi JMV

Try

=if(if(or(a1>0,a2>0),and(a3=0)),"footnote A","")

hope this helps
regards from Brazil
Marcelo

> I need a formula for the below:
>
[quoted text clipped - 3 lines]
> I have been trying If formulas with And and I can not seem to figure
> this out - I would appreciate all help. - Thank you.

Reply to this Message

jmv - 20 Jun 2006 23:01 GMT

let me try to restate this

if either a1 is greater than zero or a2 is greater than zero and a3 i
zero - then "footnote A"

a1 a2 a3 a4
1 1 0 footnote a
1 0 1 blank
1 1 4 blank
0 1 0 footnote a

Thank you once again for all your help

Reply to this Message

Bearacade - 20 Jun 2006 23:10 GMT

HTH

=IF(AND(A3=0,OR(A1>0,A2>0)),"","footnote A"

--
Bearacad

Reply to this Message