Entering a % or Amount to calculate a new number

[talkmauro]

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.

	Old	%	Amt	New
	1000	10%	100	1100
or
	1000	10%	100	1100

<tbody>
</tbody>

 

[dreid1011]

WOW, that works great!! Thank you so much.

You're welcome.