Exponent Formula Issue
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi,
I am trying to do an exponent formula
POW((1+[Coupon]/200),(2/12)- 1) , which is getting 0.99355
But in excel I am getting =((1+V14/200)^(2/12)-1).
0.001295 |
Coupon or V14 = 1.5595.
Where am I going wrong?
Solved! Go to Solution.
- Labels:
- Custom Tools
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hey @wonka1234,
In your excel formula the -1 is not part of the power exponent. eg. you have done (1+V14/200)^(2/12) then minus 1.
Whereas you have included -1 as part of the power Exponent eg. in the Alteryx formula is (1+V14/200)^(2/12-1).
I think you want your Alteryx formula to be POW((1+[Coupon]/200),(2/12))-1
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
This is due to BODMAS math rule
Exponentiation is performed before division and you are not putting brackets to allow 2/12-1 to happend beforehand. Putting brackets around (2/12-1) will help
That is the reason for different anwers.
instead of ((1+V14/200)^(2/12)-1) if you put ((1+V14/200)^((2/12)-1)) in excel you will get same answer
