You still did not tell where 5000 is coming from. If column E must contain a formula as well allow for a user entry, the task is not doable as such because these two ways cannot exist together within a range where the formula must be copied down.