Existing excel document needs additional fuctionality
- or -
Post a project like this2682
$
- Posted:
- Proposals: 2
- Remote
- #1377853
- Completed
Description
Experience Level: Entry
I need the below described functionality added to the attached document.
I will have many similar assignments as we continue to build additional documents.
1) If cell H88 is a negative number than I need the check box located to the left of Cell H88 to be checked
If cell H88 is a positive number than I need the check box also located to the left of Cell H88 to be checked
2) Cell E9 needs to have two solutions depending on which check box is selected by the user, (A92 or A93 “Interest only” or “Amortized” ).
If “interest only” is checked than the following formula =I81*E91/12 would provide the solution in cell E9.
If “Amortized is checked” is checked than this formula =PMT(E91/12,E92/12*12,-I81) would provide the solution in cell E9.
I will have many similar assignments as we continue to build additional documents.
1) If cell H88 is a negative number than I need the check box located to the left of Cell H88 to be checked
If cell H88 is a positive number than I need the check box also located to the left of Cell H88 to be checked
2) Cell E9 needs to have two solutions depending on which check box is selected by the user, (A92 or A93 “Interest only” or “Amortized” ).
If “interest only” is checked than the following formula =I81*E91/12 would provide the solution in cell E9.
If “Amortized is checked” is checked than this formula =PMT(E91/12,E92/12*12,-I81) would provide the solution in cell E9.
Tod C.
100% (3)Projects Completed
2
Freelancers worked with
2
Projects awarded
20%
Last project
10 Aug 2018
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