|First, a posting tip...|
When posting in a help forum such as this, please try to use a subject line that gives the readers some idea about the specific issue you are having. If every thread had a subject such as "How to write an Excel formula" we wouldn't be able to tell one thread from another and the archives would basically be useless.
I have edited your subject line so that it is relevant to your question. Take a look at some of the other subject lines in this forum to see what a good subject line looks like.
As for your question, I assume you are trying to have a cell display 15, 10, or 0 based on the contents of B1. An Nested IF statement can do that:
This assumes that B1 will always contain FT, PT or CN.
If it might contain another value, or even be empty, then you need to deal with those situations. For example, this will produce a blank cell unless B1 contains FT, PT or CN:
=IF(B1="FT", 15, IF(B1="PT", 10, IF(B1="CN", 0, "")))
Excel Forum Moderator
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.