=IF(Q10P10,1,IF(Q10=P10,IF(Q8P8,1,0),0))

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Nigel" wrote in message
...
Having a small problem with a nested if, here is the syntax

if Q10p10 then I want the result to be 1 else 0

But

but if q10=p10 then if q8p8 then 1 else 0

thanks in advance