function with IF, OR, & AND

[Trishcuria]

I have the following as an example

A B C

1 0 5
2 0 0

I need a formua which will return in column C the following:

If a & b are both equal to zero, then "" (blank), but if a is equal to 0 and
b is greather than zero, then C needs to equal 125%.

I cant seem to be able to combine both of these elements into one formual

 

[Luke M]

And what happens if neither of those criteria are met?

=IF(AND(A2=0,B2=0),"",IF(AND(A2=0,B2>0),125%,"Criteria not met"))

 

[Mike H]

Maybe this formatted as %

=IF(AND(A1=0,B1=0),"",IF(B1-A1=B1,1.25,""))

--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.

 

[Eduardo]

Hi,

=if(and(A1=0,B1=0),"",if(and(A1=0,B1>0),1.25,""))

 

[Trishcuria]

Thanks for the quick reply - did the job brilliantly!

 

[confused!!]

can you look at my question - look up across multiple sheets?

 

[Joe User]

I need a formua which will return in column C
the following:
If a & b are both equal to zero, then "" (blank),
but if a is equal to 0 and b is greather than zero,
then C needs to equal 125%.

=if(a1=0, if(b1>0, 125%, ""), "")

formatted as Percentage.

Note that this also returns blank when A1 is not zero, regardless of what B1
is. You neglect to explain what you want in that case.


----- original message -----