FYI

In XL2003 and lower the limit to nested functions (including IF) is 7
For XL2007 the limit is 256

--
Regards

Roger Govier


"Andrea" wrote in message
...
Hi,
try this
=IF((AND(A3=0,B3<0)),B3+B6,IF((AND(A3<0,B3=0)),B 6-A3,"conditions not
meet")).

PS not sure how many nested IF Excel xp allows (i guess more than one,
but i
never used it).
Andrea

"maud0361" wrote:

Using XP and Excel 2003-how do I create a formula for the following
outcome:
Cell A3 is nil, cell B3 has a value of say $500.00. I want to add
cell B3 to
say cell B6 which has a value of say $1000, but if cell A3 has a
value and B3
is nil I want to subtract A3 value from B6.