HELP!!! How to Nest AND OR functions

[bullandbear1987]

I am attempting to nest the and or functions.

I would like the argument to state:

IF C47 and D47 are negative... take the absolute value of g47/d47
IF C47 or D47 are negative.... take g47/c47+1
IF C47 and D47 are not negative... take g47/d47


Here is what i have written.... can someone please help?????? IT IS
GIVING ME ERRORS


=IF(AND(C47,0,d47<0),abs(g47/d47),OR(C47<0,D47<0),(G47/C47+1),(G47/D47))

 

[Mika]

Hi,

=if(and(C47<0,D47<0),ABS(G47/D47),if(or(C47<0,D47<0),G47/D47+1,if(and(C47>0,D47>0),G47/D47,"nothing")))

 

[Guest]

=IF(AND(C47<0,D47<0),ABS(G47/D47),IF(OR(C47<0,D47<0),G47/C47+1,G47/D47))

Vaya con Dios,
Chuck, CABGx3

 

[bullandbear1987]

Thanks a bunch guys... I really appreciate it