If(and statement - displaying the text result in a different cell?

[jgold20]

Is it possible to display the text result of an IF(AND statment in a different cell? My IF(AND statement is in cell G9. I want the text to display in G10?

=IF(AND($I$3<>"NO",$C$3="",$A$9=""),G10="Enter Cf in C3","bbbbb")

Thank you

 

[jasonb75]

The short answer is no. A formula in G9 can only display an answer in G9, a formula in G10 can only display and answer in G10 etc.

For anything beyond that you would need to use vba.