
Excel formula quick help URGENT
- or -
Post a project like this4086
$20/hr
- Posted:
- Proposals: 3
- Remote
- #599805
- Completed
Description
Experience Level: Intermediate
Estimated project duration: 1 day or less
Urgently need help to understand an Excel formula (found online) so I can applied it to my own data. Here is the formula and I will provide the data to the person who takes the job.
I need just a description in simple words of every step of the calculations used in this formula.
Due: ASAP (Monday morning before 7am U.S. Pacific Time)
Please reply and I will send you the excel file so you can also look at the formula in it - as it is applied. Here is the formula:
=IF(IF(D15>$C$4=TRUE,1-I15/GETPIVOTDATA(" CPA",$A$13),"Not Statistically Significant")="Not Statistically Significant",IF(D15>$C$4=TRUE,1-I15/GETPIVOTDATA(" CPA",$A$13),"Not Statistically Significant"),IF(IF(D15>$C$4=TRUE,1-I15/GETPIVOTDATA(" CPA",$A$13),"Not Statistically Significant")>900%,900%,IF(IF(D15>$C$4=TRUE,1-I15/GETPIVOTDATA(" CPA",$A$13),"Not Statistically Significant")$C$4=TRUE,1-I15/GETPIVOTDATA(" CPA",$A$13),"Not Statistically Significant"))))
I need just a description in simple words of every step of the calculations used in this formula.
Due: ASAP (Monday morning before 7am U.S. Pacific Time)
Please reply and I will send you the excel file so you can also look at the formula in it - as it is applied. Here is the formula:
=IF(IF(D15>$C$4=TRUE,1-I15/GETPIVOTDATA(" CPA",$A$13),"Not Statistically Significant")="Not Statistically Significant",IF(D15>$C$4=TRUE,1-I15/GETPIVOTDATA(" CPA",$A$13),"Not Statistically Significant"),IF(IF(D15>$C$4=TRUE,1-I15/GETPIVOTDATA(" CPA",$A$13),"Not Statistically Significant")>900%,900%,IF(IF(D15>$C$4=TRUE,1-I15/GETPIVOTDATA(" CPA",$A$13),"Not Statistically Significant")$C$4=TRUE,1-I15/GETPIVOTDATA(" CPA",$A$13),"Not Statistically Significant"))))
Milena M.
100% (3)Projects Completed
4
Freelancers worked with
3
Projects awarded
56%
Last project
13 Nov 2015
United States
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies