nested AND and IF statements

[DrPips]

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

[Jonmo1]

Is it only the 2 possible values for column I (10 or 12) ?
Or will that expand out to several possible values? How Many?

If it's really just the 2, try

=IF(J2="Yes",IF(I2=10,56,IF(I2=12,65,"")),0)

[DrPips]

That's perfect thanks. Just the 2 possible values in that cell.

Thanks again

[Jonmo1]

You're welcome.