Changing true and false

A

Andrew Gill

How do I do a formula where, rather than using TRUE and FALSE, I can
enter WON or LOST?
 
H

Harlan Grove

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

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.
 
D

Dave R.

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.
 
A

Andrew Gill

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top