Excel lookup function or conditional formula?

**atlpersonnel** · 06-14-2012, 11:05 AM

I'm not sure which is the correct approach to use here, but I am trying to create a spreadsheet that will allow me to sum any unpaid invoices and then compare this value with a user inputted credit limit.

There will be a column containing the amount due for each invoice, and another column where a value ("y") will be entered if the invoice has been paid. There will then be a box which shows the total amount of all unpaid invoices (where there is no "y" in the Paid column). If the amount in this total unpaid invoices cell is below the credit limit, a further cell will display "Supply", if the value exceeds the clients credit limit the cell will display the value "Do not supply".

Does anyone know how best to go about this?

Thanks,

Mark

**NBVC** · 06-14-2012, 11:31 AM

Assuming data in
A2:A10 and y's in B2:B10

to sum the values with "Y", =SUMIF(B2:B10,"Y",A2:A10)

then assuming you put that in B11

=IF(B11<X1,"Supply","Do Not Supply")

where X1 contains the credit limit.

**Sky188** · 06-14-2012, 12:48 PM

Dear atlpersonnel,

You could use NBVC's option, but I believe my solution is a bit closer to what you are looking for. Attached is a file I created to reference everything. If And And Statements.xlsx

If you have any questions, let me know!