Nested if statement

[Blake 7]

Hi Guys –

Struggling here!

Am looking for a complicated (for me) nested if or and not else then statement…….!!

Here goes

IF AT2=1 AND BO2 < 1.63 then “0.06” AND IF AT2=1 AND BO2 is NOT <1.63 then 1.63 - BO2
AND IF BO2 = 1.63 AND AT2 is NOT 1 then “0”

Cheers fellas

[NBVC]

I think this should do it:

=IF(AT2=1,IF(BO2<1.63,0.06,1.63-BO2),0)

[ConneXionLost]

How about:

Please Login or Register  to view this content.

Cheers,

[Blake 7]

thanks guys - for your help. perfect