I really need some help with a formula for a cell to calculate a figure based on another cell.
Below is an illustration of the formulas that are needed. I am trying to take a backdoor approach the cell formula due to I am unable to use the indirect process like with multiple sheets in excel on a form application within dreamweaver.
<tbody>
</tbody>
thanks! Heidi
Below is an illustration of the formulas that are needed. I am trying to take a backdoor approach the cell formula due to I am unable to use the indirect process like with multiple sheets in excel on a form application within dreamweaver.
SELECTION NUMBER | 1-15 (CAN BE SELECTED) |
TOTAL AMOUNT | 1000.00 |
FP | IF SECTION NUMBER IS 1 THEN THIS CELL WILL BE 100% OF THE TOTAL AMOUNT.IF THE SELECTION NUMBER IS 2 THEN THIS CELL WILL BE 60% OF THE TOTAL AMOUNT |
SP | IF SECTION NUMBER IS 1 THEN THIS CELL WILL BE 0% OF THE TOTAL AMOUNT. IF THE SELECTION NUMBER IS 2 THEN THIS CELL WILL BE 40% OF THE TOTAL AMOUNT |
TP | IF SECTION NUMBER IS 1 THEN THIS CELL WILL BE 0% OF THE TOTAL AMOUNT. IF THE SELECTION NUMBER IS 2 THEN THIS CELL WILL BE 0% OF THE TOTAL AMOUNT. iF SECTION NUMBER IS 3 THEN THIS CELL WILL BE 35% OF THE TOTAL AMOUNT |
<tbody>
</tbody>
thanks! Heidi