Excel Logic Checking Problem

[treeantz]

Hi all, I have a logic i would like to check in my excel sheet but couldn't figure out the correct syntax to get it to work. I really hope someone could lend me a helping hand.

Here's the scenario

I would a cell to return the value "1" if the following conditions are met

Status = "Completed purchase form"
Payment Status = "Payment via credit card" OR "payment via cheque"

AND

Received Date = must be filled in

Here's what i came out so far

Cell A's formula (1 = false, 0 = true)

=IF(AND([@Status]="Completed purchase form",[@[Payment Status Status]]="Payment via Credit Card",[@[Received Date]]=""),1,IF(OR([@Status]="Completed purchase",[@[Follow On Status]]="payment via cheque",[@[LOE/SAR Received Date]]=""),1,0))

Again, any help will be appreciated.
Thanks in advance

 

[Robert Mika]

Hi treeantz,
Wecome to the board.
I do not know what the "@" mean in your formula but
I named my cell as fallow:

B1=Status
B2= Payment Status
C2= ReceivedDate

and the formula is:

=IF(AND(Status="Completed purchase form",OR(Payment_Status="Payment via Credit Card",Payment_Status="payment via cheque"),ReceivedDate<>""),1,0)

 

[treeantz]

Thanks Robert, what you shared with me works! appreciate it