Hi All,

You won't have any problem with this, but I can't get the syntax correct.

If try to write a formula that looks at column J to see if there is a Yes, and if there is, looks at column I. If the value in column I is 10, it should return 56. If the value in column I is 12, it should return 65. If column J shows No instead of Yes, it should return 0 regardless of column I.

I always struggle with nested stuff, any help as always greatly appreciated.

Thanks,

Dom