if function

[shital]

hi

I have 2 worksheet where in Sheet1 A5 i have name X
and in sheet2 also A5 name x and in sheet1 a10 has amt.
What i want is
if sheet1 & sheet2 name are same & if Sheet1 a10 is (-ve
value)it should take the value if it's +ve it's should
be "0"
thanks

shital

 

[Norman Harker]

Hi Shital!

Try:

=IF(AND(Sheet1!A5=Sheet2!A5,Sheet1!A10<0),Sheet1!A10,0)