function with IF, OR, & AND
 

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

function with IF, OR, & AND
 

And what happens if neither of those criteria are met?

=IF(AND(A2=0,B2=0),"",IF(AND(A2=0,B20),125%,"Crit eria not met"))

--
Best Regards,

Luke M
"Trishcuria" wrote in message
...
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

function with IF, OR, & AND
 

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.


"Trishcuria" wrote:

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

function with IF, OR, & AND
 

Hi,

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

"Trishcuria" wrote:

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

function with IF, OR, & AND
 

Thanks for the quick reply - did the job brilliantly!
"Mike H" wrote:

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.


"Trishcuria" wrote:

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

function with IF, OR, & AND
 

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

"Eduardo" wrote:

Hi,

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

"Trishcuria" wrote:

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

function with IF, OR, & AND
 

"Trishcuria" wrote:
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(b10, 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 -----

"Trishcuria" wrote:
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