Richard
Elite Member
- Joined
- Apr 6, 2000
- Messages
- 4,822
- Location
- Knoxville, TN
- Tractor
- International 1066 Full sized JCB Loader/Backhoe and a John Deere 430 to mow with
I’m befuddled...
I’m trying to make a formula in Excel (learned on Lotus) and since they seem to do it differently, I’ve become confused.
In LOTUS, what I think my formula would be is
“IF((J4-I3)/I3)<=0,((J4-I3)/I3),IF((J4-I3)/I3)>0#and#((J4-I3)/I3)<=.0325,((J4-I3)/I3),If((J4-I3)/I3)>.0325,.0325”
What I’m trying to do is find a rate of return. If the rate of return is less than zero, enter the negative. If it’s UP to and including 3.25%, then use the real number, if it’s greater than 3.25%, then use 3.25% as a cap.
Anyone care to push (or kick) me in right direction in Excel?
(gentle kicks preferred) /forums/images/graemlins/tongue.gif
I’m trying to make a formula in Excel (learned on Lotus) and since they seem to do it differently, I’ve become confused.
In LOTUS, what I think my formula would be is
“IF((J4-I3)/I3)<=0,((J4-I3)/I3),IF((J4-I3)/I3)>0#and#((J4-I3)/I3)<=.0325,((J4-I3)/I3),If((J4-I3)/I3)>.0325,.0325”
What I’m trying to do is find a rate of return. If the rate of return is less than zero, enter the negative. If it’s UP to and including 3.25%, then use the real number, if it’s greater than 3.25%, then use 3.25% as a cap.
Anyone care to push (or kick) me in right direction in Excel?
(gentle kicks preferred) /forums/images/graemlins/tongue.gif