This is the formula
=IF(K3,J2+I3,J2-E3)
J2+I3=TRUE
J2-E3=FALSE
could you explain step-by-step how to difine names, so that I can
enter WON for the first one, and LOST for the other.
Sorry about this, I am still trying to learn my way around excel.
Thank you for your patience