I am trying to figure out how to set up an excel calc to allow a user to enter a percentage or amount (see red text below) in adjacent cells to calculate a new value. If they enter a percent, it automatically calcs the amount and vis versa. It needs to be dynamic enough to go back and forth between the two values so if they try a percent but then want to switch to an amount they can do it without remembering to delete the value in the % or amount field.
<tbody>
</tbody>
Old | % | Amt | New | |
1000 | 10% | 100 | 1100 | |
or | ||||
1000 | 10% | 100 | 1100 |
<tbody>
</tbody>