Nested Mess

[mrowe]

HELP!

I'm not sure how to get 3 things into a nested statement.

Here's the logic (mmmm?)

IF G1 NOT "" AND I1 > 0 Then "PAY AGREED"
OR IF I1 = ISERROR Then "Reject Copy"

is this possible.
I'm sure it is, but it's friday afternoon

Thanks
Matt

[crimlet]

I think this is it

=IF(G1<>"",IF(I1>0,"Pay Agreed",""),"notagreed")

but without test data cant be sure

[mrowe]

could you explain the syntax....

[crimlet]

if g1 is not equal to blank,then if i1 is greater than 0 "pay agreed" else pay not agreed (I think)

[Dave Patton]

Your information is not complete; you can try the following.

=IF(ISERROR(I1),"Reject Copy",IF(AND(G1<>"",I1>0),"Pay Agreed",""))

[mrowe]

thanks...I think I've got it now!
Matt

[Aladin Akyurek]

On 2002-05-03 07:34, mrowe wrote:
HELP!

I'm not sure how to get 3 things into a nested statement.

Here's the logic (mmmm?)

IF G1 NOT "" AND I1 > 0 Then "PAY AGREED"
OR IF I1 = ISERROR Then "Reject Copy"

is this possible.
I'm sure it is, but it's friday afternoon
[img]/board/images/smiles/icon_smile.gif[/img]
Thanks
Matt

You need to specify the data type of I1 and G1 may possibly take on, in particular when you mention ISERROR wrt I1.

Try this:

=IF(LEN(G1),IF(ISNUMBER(I1),IF(I1,"PAY AGREED","I1 is 0: What Now?"),"Reject Copy"),"G1 is kind of blank: What Now?")



Aladin