Forum Discussion
Issue Writing IF Formula
Hi all,
There is probably a simple solution but I am not very skilled at excel and would love your feedback. I have tried to search other posts to see if someone has had a similar question to try but have not found something similar.
I am trying to write a formula that will determine whether a postcode is in a category 1 location or not. I thought the IF formula would be the best equation but maybe it is not?
The issue is it will be hundreds of postcodes (across all states), some individual numbers and others that will be a range.
EG. 2000,2007-2011,2015-2020,2022-2043,2045-2050,2118 etc.
Thank you for your help!
Hi Cassie
I've had a bit of a play. Try the worksheet I've attached where I have input all the Cat 1 Postcodes into a sheet called Category 1, and I have created a formula on another sheet.
The formula I have used will reference the Category 1 postcodes and produce your desired result:
=IF(COUNTIF('Category 1'!A:F,A2)>0, "Cat 1", IF(A2="", "", "N/A"))
Let me know how you go? Hopefully this helps with a workable solution for you.
Cheers
Damien
9 Replies
Hi Cassie
What do you classify as a category 1 location?
Is that the only requirement? If it meets that criteria list at Category 1 else it's not?
Cheers
Damien
Hi Damien,
Thank you for your reply!
I am working off a guide which classifies which postcodes are Category 1 for properties. See attached
Yes, that will be the only requirement.
If it is one of the postcodes or falls within the range then it is CAT 1, if the postcode does not fall within the range then it is Other or N/A
Hi Cassie
Are you also looking to have a single cell to write a Postcode in and to have it return a Cat 1, N/A result?
I thought I was looking at Australian Postcodes, Melbourne here!
Cheers
Damien
