Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Basic question: how do I change these in to functions?
I have a cell that contains the following:
=IF(AC2<11,"A",IF(AC2<16,"B","C")) How would I convert this into a function? How about the following? =OR(AND(AA2=0.333,AA2<=0.458),AND(AA2=0.6666,AA2 <=0.8953)) I think I can figure out the flow of the first one, but I am not sure how to return the value... I take it that the cell should have something like =MyTestFunction() then the functions should be something like: Sub function MyTestFunction if AC2 < 11 returnValue = "A" elseif if AC2 <16 returnValue = "B" else returnValue = "C" endif endif end sub TIA, Phil |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Basic question: how do I change these in to functions?
Public Function Myfunction( rng as Range)
if rng.Value < 11 then myfunction = "A" elseif rng.Value < 16 then myfunction = "B" else myFunction = "C" end if End Function =MyFunction(AC2) "Phillips" wrote in message news:f8Nub.245493$HS4.2174899@attbi_s01... I have a cell that contains the following: =IF(AC2<11,"A",IF(AC2<16,"B","C")) How would I convert this into a function? How about the following? =OR(AND(AA2=0.333,AA2<=0.458),AND(AA2=0.6666,AA2 <=0.8953)) I think I can figure out the flow of the first one, but I am not sure how to return the value... I take it that the cell should have something like =MyTestFunction() then the functions should be something like: Sub function MyTestFunction if AC2 < 11 returnValue = "A" elseif if AC2 <16 returnValue = "B" else returnValue = "C" endif endif end sub TIA, Phil |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Visual basic functions | Excel Worksheet Functions | |||
Really basic question! Cell colours change when emailed. | Excel Discussion (Misc queries) | |||
Excel n00b, how to do basic math functions | Excel Worksheet Functions | |||
Basic excel functions | Excel Worksheet Functions | |||
Using Basic Excel Functions | Excel Programming |