"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