View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Phillips Phillips is offline
external usenet poster
 
Posts: 48
Default 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