Thread
:
complex formula
View Single Post
#
4
Posted to microsoft.public.excel.misc
Sandy Mann
external usenet poster
Posts: 2,345
complex formula
Try:
=IF(A165,"3",IF(A155,"A2",IF(A144,"2B",IF(A137 ,"2C",IF(A129,"1","W")))))
--
HTH
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
with @tiscali.co.uk
"Lou" wrote in message
...
i have a list of random numbers in column A1 0-75. i am trying to make a
formula that will predict results based on the number in column A that
will
appear in column B
up to 29 should result in a letter W in column B
30 - 37 should result in a number 1
38 - 44 should result in 2C
45 - 55 should result in 2B
56 -65 should result in 2A
66 and over should result in 3
Have been trying all day, can get the numbers but as soon as I try to add
letters I am lost. any help would be greatly appreciated.
Reply With Quote
Sandy Mann
View Public Profile
Find all posts by Sandy Mann