Formula for "unavailable"

[Dummy Excel]

Hi All,
I have some data with two columns with data (data is either available or unavailable in each column) The unavailable status trumps the available status in either column
can someone please help with a formula to compare and place the results in column K?

thanks
Sam

Book1
	H	I	J	K
2	Rego	Status	Status	Result
3	banana	Available	Available
4	apple	Unavailable	Available
5	cheese	Available	Unavailable
6	bread	Unavailable	Unavailable
North Vehicle Status

 

[Weazel]

maybe something like...

=IF(COUNTIF(I2:J2,"unavailable"),"Unavailable","Available")

 

[Dummy Excel]

thanks Weazel, that works

i also just got mine to work =IF(AND(D6="Available",E6="Available"),"Available","Unavailable") - i put the second last bracket at the end which is why it wasn't working for me