Subtract number from column C4 and put result in D4

[PhilipeC]

After a number is written in column C4, i would like to subtract 1850 - (Number), such as C4=2000 than 1850 - 2000 = -150, the result would be in right column D4, D4=-150. The number 1850 would come first subtracted by Number, such as 1850-(number) resulting in D4.

 

[JoeMo]

In D4 enter:

=IF(C4="","",1850-C4)

 

[PhilipeC]

Thank you

 

[JoeMo]

Thank you

You are welcome - thanks for the reply.