Cell auto-update IF function with complication

[rtelectric]

Hey all,

First, I want to thank ExcelForum for the help I received last time [thank you, JBeaucaire].

Now, to my issue:

I have a cell [Tracking!L3] which lists a "Job Total" for a job. It requires the user to input a value for the job, say for example, $10. In the same workbook, but on a separate sheet [titled "Change Orders"], sometimes there will be an input, say for example, $1. The inputs are totalled in cell 'Change Orders'!B14.

I essentially, need a complex IF function, but I don't know how to write it.
A job total will have a user input [which raises the problem]
The user input will need to be added to/auto-updated IF there's a value input into the Change Order sheet.

EXAMPLE:
[Original Input by User] + IF('Change Orders'!B14=0,"[Original Input by User]","[Original Input by User]"+'Change Orders'!B14)
[Figured this format might help some better understand what I'm asking.]

Is there a way to mix a formula with user input like this without getting too advanced? [I've only done one macro, which was written entirely by someone else [see above]]

Thanks in advance for any help.

RT Electric LLC.

[NBVC]

Do you want?

=Tracking!L3 + IF('Change Orders'!B14=0,Tracking!L3,Tracking!L3+'Change Orders'!B14)

or maybe just:

= IF('Change Orders'!B14=0,Tracking!L3,Tracking!L3+'Change Orders'!B14)

because the first formula will double up the Tracking!L3 value.

[rtelectric]

The latter, I don't want the Tracking!L3 value to double, I just want it to display the original user input if there's no change to 'Change Orders'!B14. And if there is a change, (i.e. x>0), I want it to add that cell to the original user input and display that instead.

[NBVC]

So does the latter work? Not sure if this is solved

[rtelectric]

Regrettably, it does not. It would work if it was perfectly automated but it has to have the user input + the automation which is the complication.

I've attached a copy of the template I'm trying to do this with, perhaps it can help clear some up.[

[NBVC]

You can't really overwrite a manual entry with a formula result... (unless you use VBA).

I suggest you create another separate Original Input field (say cell N3, you will have to find a better spot)... then the formula in L3 would simply be:

=N3+'Change Orders'!B14

[rtelectric]

Figured as much with the VBA.

Would it be complex?