mslattery@dc.rr.com
91 posts
msg #105713
- Ignore mslattery@dc.rr.com |
3/28/2012 2:30:06 AM
Can someone provide me with the correct format to accomplish the following?
I want to assign values to the following percentages derived from the difference between the High of the day and the Close of the Day.
I want to assign the value of: "5" if the resulting % is less than .25%
of: "4" if the resulting % is less than .50%
of: "3" if the resulting % is less than 1%
of: "2" if the resulting % is less than 2%
of: "1" if the resulting % is less than 3.5%
of: "0" if the resulting % is greater than 3.5%.
Thanks, Michael
|
Kevin_in_GA
4,599 posts
msg #105721
- Ignore Kevin_in_GA |
3/28/2012 12:30:13 PM
I don't think this can be done. You are thinking this is like an IF() statement in Excel, the current SF programming language does not support this.
|
mslattery@dc.rr.com
91 posts
msg #105723
- Ignore mslattery@dc.rr.com |
3/28/2012 2:15:52 PM
Thanks Kevin:
Yes, I was actually trying to get an excel function out of excel and into SF.
I was hoping that someone had tricked this out.
Michael
|
traderseb
36 posts
msg #105732
- Ignore traderseb |
3/29/2012 8:01:07 AM
This might work......
|