Problem with IF formula in Query

[Riaang]

Hi all,

I have a database on which I wrote some queries. On query is to group different codes together. For eg. in column A I have different kinds of codes. Now in column B I want like a group name.

I have tried the IF formula but are stuck. What I want in the if formula is te following.

If column A = Collect_Y then put Pending in column B, if column A is null then put Active in column B and if column A = any thing else (not null and not = Collect_Y) then put Suspended in column B

Example.
.......A.....................B
1...Collect_Y.........Pending
2...Group.............Suspended
3...Collect_Y.........Pending
4...(empty)..........Active
5...0003..............Suspended
6...(empty)..........Active

I would appreciate any help.

Thanks

 

[sree_31]

Try Something like this

=IF(ISBLANK(A3),"ACTIVE",IF(A3="COLLECT_Y","PENDING","SUSPENDED"))

 

[Riaang]

Thanks a lot sree_31, it works like a bomb.

Regards