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