Is it possible to use ISTEXT or another command to identify if one cell contains some text then a number is automatically entered in another cell (ideally sourcing the number to be entered from a third cell) I hope that makes some sense - thank you

---

Answer from Richard Rost:

Sure. Just wrap the ISTEXT function inside of an IF function:

=IF(ISTEXT(A1),"text","not text")

If you want to substitute values from other cells in there, you can too:

=IF(ISTEXT(A1),B1,C1)

You can use the IF function to have Excel place a value in a cell based on one or more conditions or values in other cells.

See this FREE tutorial on my web site for more information on how to use the IF function:

http://www.599cd.com/tips/excel/misc/if-function-sales-tax.asp?key=BlFAlEx