Hi,

I did a search and couldn't find anything to help.

I need to two cells C5 and E5 to be 0% and 0 respectively.

However If the user enters a percentage into C5, then E5 = C5 * B5
If the user enters a number into E5 then C5 = E5/B5

Where B5 is some integer. However I keep getting called up on a circular function.

Is there anyway around this? To have two cells that are autofilled when one or the other is entered with a value?

Thanks in advance