How can i add a 'but-if' then.....variable to a formula?

Can someone help me with extending/amending the following formula please? It does exactly what it states but I need to add a variable and my efforts thus far result in error after error; might have something to do with my level of experience which isn’t all that flash!!!

=IF(AND(ISBLANK('Transactions Register '!AC10),ISBLANK('Transactions Register '!AU10),ISBLANK('Transactions Register '!BK10),ISBLANK('Transactions Register '!CG10)),"AVAILABLE ","SOLD")

Formula is in H10 on sheet ‘Inventory Listing’ and needs to tell me if the item, in the corresponding row on sheet ‘Transactions Register’, is AVAILABLE or SOLD. All reference cells are dates; however, AC10 = Cash Sales Date
BK10 = eSale Date
AU10 = Cash Refund Date
CG10 = eSale Refund Date

So what I want to achieve is:
If all cells are empty return AVAILABLE
If cells AC10 or BK10 are not empty return SOLD
If cells AU10 or CG10 are not empty return AVAILABLE
This needs to be the case even if AC10 or BK10 are populated, as the item will have been returned and refunded and is therefore available but I still need to retain the sales date for record keeping etc.

Appreciate your help

It seems to me that the only condition where you would have SOLD is when you have a date in AC10 or BL10.

Therefore, I would use =IF(COUNT('Transactions Register'!AC10,'Transactions Register'!BK10)>0,"SOLD","AVAILABLE")

This is a bit simpler than IF(AND...)

I hope this helps, please let me know!

Regards,

David


- Please click on the *Add Reputation button at the bottom of helpful responses.

Please mark your thread as SOLVED:
- Click Thread Tools above your first post, select "Mark your thread as Solved".

Hi David thanks for your prompt help; I like your logic clearly I have none lol!!! Your formula didn't initially work but after a bit of research it worked by starting =IF(COUNTA( instead of =IF(COUNT(

Thanks again

Cheers
Brett

Thanks Brett,

I guess I used COUNT instead of COUNTA because I thought you were working with dates. (I note that Ford offered a similar solution - he used COUNTA)

Regards,

David

Thanks Brett,

I guess I used COUNT instead of COUNTA because I thought you were working with dates. (I note that Ford offered a similar solution - he used COUNTA)

Regards,

David


- Please click on the *Add Reputation button at the bottom of helpful responses.

Please mark your thread as SOLVED:
- Click Thread Tools above your first post, select "Mark your thread as Solved".