Conditional statements

  • Thread starter Thread starter Mark
  • Start date Start date
M

Mark

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

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

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

What is the simplest way of doing this?

I'm heading something like this right now, but there's got
to be any easier way.

=COUNT(F6:F105)My Range
If Check Box Enable then True

Then I was going to count the True statement which if
equals the count then all items are paid.

Even though I think this will work it doesn't seem like
the best way. I will have to go and change every Check Box
to make it select each cell. I have over 500 check boxes
to change.
 
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
Click to expand...
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.
 
Back
Top