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