Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |