Changing true and false

  • Thread starter Thread starter Andrew Gill
  • Start date Start date
A

Andrew Gill

How do I do a formula where, rather than using TRUE and FALSE, I can
enter WON or LOST?
 
How do I do a formula where, rather than using TRUE and FALSE, I can
enter WON or LOST?
Click to expand...

If you mean is there sume way to use WON and LOST as tokens in formulas just
like TRUE and FALSE, then define them as names, WON referring to =TRUE and LOST
referring to =FALSE. If you mean something else, details would help, like a
sample formula. Don't depend on others to be able to read your mind.
 
I don't think Andy reads any follow-ups to his messages, but I know exactly
what he wants to do: if(x,"word1","word2") rather than the if(x) default
response of true or false. If he kept his questions in the same thread -- or
bothered to read replies to them -- he would have been done with this hours
ago.
 
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
 
Back
Top