ExcelBanter - View Single Post

David

in article , Mark at
wrote on 31/12/2003 11:40 AM:

Hello and thanks in advance,

I am trying to get a cell to say "Paid", or "UnPaid",
conditioned by a row that is used and a check box and over
a range.

Sample:
UnPaid
Sample:
UnPaid

Cust cost Paid
Acme 10.00 √
Baits 223.00
Hamms 2.00 √
Unused Row's
------------------------------------------------------

A B C D
1 Cust cost Paid STATUS
2 Acme 10.00 √ =IF(C2="","Unpaid","Paid")
3 Baits 223.00 copy down
4 Hamms 2.00 √
5 Unused Row's

Then select the headings (Cust, Cost, Paid, Status) and then choose, from
the menu bar, Data-Filter-AutoFilter You will then be able to filter the
list by paid or unpaid, by customer, by amounts. I have a working example I
will send if you send me your email.

--

Remove nospam