Hi,
I am creating a spreadsheet for building audits. In one column called "Condition" I have a drop down list to choose the condition of items in the building.
The three options are: Good, Average and Poor. I need these options to have a numerical value that will automatically appear in the "Rating" column.
Good = 1
Average = 2
Poor = 3
For example: Once I have selected "Average" in condition column I need the rating column to contain a 2 excel.JPG
take a look at the attachment and figure out for yourself if it is humanly possible to see what is in it.
as far as your issue is concerned (going by the text), you can use a simple IF statement to get your desired result. if Condition is in A1, you can use something like the following in B1:
=if(a1="Good",1,if(a1="Average",2,if(a1="Poor",3,"")))
- i.s.z -
CSE, aka Array aka { }, formulae are confirmed with CONTROL+SHIFT+ENTER.
Replace commas ( , ) with semicolons ( ; ) in formulae, if your locale setting demands.
All good ideas are courtesy resources from this forum as well as others around the web.
- e.o.m -
Sorry, it's my first time posting in a forum and I wasn't sure about the attachment.
Thankyou for the formula though
Chloe
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks