Thanks:  0
Likes:  0

1. 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

2. I think this is it

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

but without test data cant be sure

3. could you explain the syntax....

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

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

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

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

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

User Tag List

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•