HELP!!! How to Nest AND OR functions

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

bullandbear1987 - 27 Jan 2006 16:58 GMT

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))

Reply to this Message

Mika - 27 Jan 2006 17:12 GMT

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")))

Reply to this Message

CLR - 27 Jan 2006 17:13 GMT

=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

> I am attempting to nest the and or functions.
>
[quoted text clipped - 8 lines]
>
> =IF(AND(C47,0,d47<0),abs(g47/d47),OR(C47<0,D47<0),(G47/C47+1),(G47/D47))

Reply to this Message

bullandbear1987 - 27 Jan 2006 17:29 GMT

Thanks a bunch guys... I really appreciate it

Reply to this Message